How to copy columns from one excel sheet to another based on column name
Posted on 2013-05-15
I've been given a sheet with alot of data. I want to move specific columns into new excel sheets so that i can import it into a database.
Is there any easier way than manually copying and pasting?
It would also be ideal if a string in a cell i.e. B3 of original sheet be copied into a column on the second sheet described above, with a column name that I define.