Copy Data from one workbook to another one
 

I'm looking for a methodology to copy about 50 different cells contents from
one workbook into another one.

As I have to do this a number of times, what i am looking for is a
methodology that I can adapt to suit.

Basically what I thought I would do would be to enter the cell reference
from the original date onto a spare worksheet (in a column) as well as
inputting the taget cell reference into another column.

I therefore require code that will loop through both columns, picking up the
data from the reference passed and then copying the data into the second
workbook from the second reference passed

Hope i have made this clear and that someone can help

TIA

Copy Data from one workbook to another one
 

Apologies - in the second paragraph I meant to say original DATA and not
original DATE.

"Gazza" wrote in message
...
I'm looking for a methodology to copy about 50 different cells contents
from one workbook into another one.

As I have to do this a number of times, what i am looking for is a
methodology that I can adapt to suit.

Basically what I thought I would do would be to enter the cell reference
from the original date onto a spare worksheet (in a column) as well as
inputting the taget cell reference into another column.

I therefore require code that will loop through both columns, picking up
the data from the reference passed and then copying the data into the
second workbook from the second reference passed

Hope i have made this clear and that someone can help

TIA