Copy columns from one sheet to new, rename headlines

Can you provide a sample maybe inserting a row 1 which shows where each column would be on the new sheet2. VLOOKUP sounds to me would not be the best option.

yea okay - maybe a bit hard since there is 120 columns, or well about 50 which needs to be renamed and replaced and 60-70 empty with a certain headline inserted.

but it would be something like this:
So I have what the original headlines are, and what critiera it should insert into the new sheet (ie. what the new headline should be + what number it has to be and where the empty columns and what they needs to be called) it's just that it's 120 columns, so mostly the specifications that will take time I guess once there is a VBA template where I can change the input/output?

I have found this code which can do some of it - I just need it to change the column names while it copies to the new specified numbers, is that possible

Please Login or Register  to view this content.