Copy and Paste seperate ranges in excel
 

First I am new to this so please bear with me.

I have two sheets.

First Sheet

A B C D
part part # volume location

Second Sheet:

A B C
Part part # volume

I am looking at copying the ranges to the second sheet. However the
column names do not line up as nicely as these do. I tried recording
a macro but I need to use this on more than one workbook. They are
all named different things but contain similar information.

All of the help is greatly appreciated.

Thanks in advance