Hi all... i've got what i think is a common problem, but i'm a bit stumped with it...

I need to copy data from workbook 2, into workbook 1 - then store the data on a hidden worksheet, so i can then format it & present it all...

the name of workbook 2 will vary - this is'nt a problem, as i want the user to be prompted with a dialogue box & and for them to point to the right file manually, as it may be stored in different folders etc... -

i think the workbook.open function would do it...

i could'nt find quite what i was after on the kb or in other threads - anyone got some code to hand that can do this?

Cheers

Russ