OK.
I have data in lets say workbook1 in sheet1. Columns are labeled x, y, and
z. I want to import this data to say workbook2 in sheet2. Columns in sheet2
are labeled a, b, c, x, y, and z. Now I want to make sure that the data that
i am copying over is pasted in the right columns labeled x, y, z and columns
labeled a, b, c should be all empty.
thanks much.

RK

"Don Guillett" wrote:

More detail and example(s)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"rk0909" wrote in message
...
All,

I have a two workbooks I want to copy data from one to the other using
VBA.
What I need is a macro to find specific row labels in one work sheet and
paste the corresponding data in the second worksheet.

Any help is appreciated.

thanks,

RK