Copy columns by header value and paste them in a specific order into another workbook

I have a spreadsheet with about 12 columns of data and 600 rows. I need to copy these columns from one sheet to another but they must be in a specific order. The header row cell values are the same in both sheets, so that's what I'm using to search by. Is there a way I can do a loop to run through my header values find which ones I need to copy and then copy to the last row of data for each column?

This is what I've used in other projects and it works well, except that it doesn't copy them in the order listed, it just finds the first value that matches something in the list and pastes it. :

Please Login or Register  to view this content.

Any help is greatly appreciated! Thank you!

Hi

Have you thought about using an advanced filter to copy the data?

rylo

That's a good idea, but I ended up just doing this (made a sub procedure for each search term and put in a run all procedure:

Please Login or Register  to view this content.