I need to copy columns based on column name in row 6 to the last empty
column in a different workbook.

The Excel sheet is created by a mainframe using the same file name each
time the job is run. The column names in row 6 never change. I need to
copy 4 columns every time the job is run to a consolidated sheet. The
columns are not beside each other (Columns D, AP, AR, L). The column
names are "Driver", "Payable", "Recievable" and "Total".

I need to place the copied columns in the first available empty column
in the consolidating sheet and delete the five rows above the copied
columns.

This is way beyond my knowledge. Can anyone throw this dog a bone to
learn from?

Perpetual THANKS in advance!

Craig


--
Craigm
------------------------------------------------------------------------
Craigm's Profile: http://www.excelforum.com/member.php...o&userid=24381
View this thread: http://www.excelforum.com/showthread...hreadid=380205