No she looks just like a basset hound . Look it up . <| sep |> People in other states have more power than I in choosing our president , and that is nonsense . Tell me why the imbeciles in the middle of the country get more power than I in governing my country ? <| sep |> So CoD is hard as hell to kill now since she can ' t be healed or ressed , has innate elemental resists and doesn ' t take extra damage from human killer <| sep |> So what I gather is that each row in the master sheet needs to be transposed into A 25 A 30 in separate files . OK , first Macro . Create new tab , copy Row 1 , transpose paste it in A 25 of new tab , go back to original sheet and delete Row 1 . Repeat until you have 500 tabs sounds nuts , but hear me out . Second Macro . On active tab , move tab to new workbook , save as index name . Repeat until no more tabs . I had a similar project about 15 years ago , and this is the theory behind what I did on it . I have to play around with Excel to figure out the macros behind it again , but that was the gist . Long story short two macros , one to move the data and the other to save it .