Copy columns with specified names to a newly created Sheet.

Hi,

I am pretty new to VBA and am struggling in writing a simple code.

Every day I receive spreadsheet with many columns of data, I'm trying to write a code that locates columns with the headings 'Platform' , 'Complex' , 'Field' and 'Area' and then copy the entire column (Columns may be in different cells and different lengths each time), into a newly created worksheet (not sheet 2, as each workbook may have a differnt number of sheets). And then add two new columns titles called 'TPL' and 'OPAL'.

This is what I have so far, it copies one column but i cannot get it to copy the others:

Please Login or Register  to view this content.

Any help would be much appreciated.


MOderator Note:

Pls use code tags when you post codes.