Copy macro

[pvr928]

Does anyone have a macro that is able to copy specific data from one worksheet to another?

Any help greatly appreciated.

Cheers

pvr928

 

[north19701]

what do you need copied and where to?

 

[pvr928]

north

Thanks for your reply.

From a worksheet in one file to another worksheet in another file.

In each case the data is in the same template on each worksheet. There is a need to be able to copy the data because the data may be updated, and so a need to import/copy that data into the template.

Cheers

pvr928

 

[north19701]

could you provide more detail? what is the range that needs to be copied? the location of the files? i.e...

 

[pvr928]

It sounds like I don't quite have the detail required!

The range is pending (but large - it woudl constitute specific parts of a worksheet).

I am envisaging having two files open on the screen, and the macro simply copying the new data from one into the other.

Is this what you are thinking of - or is there another way of doing it?

Cheers

pvr928

 

[north19701]

that's definitely one way in which i was thinking.
else

link the worksheet to be updated to the original (i.e. in Workbook2 place in cell A1 "=[Workbook2]Sheet1!$A$1"

and do this with all the cells you want updated.

Otherwise, provide some more detail and we'll work from there.