Copy Data between sheets with a worksheet loop

Hi,

I am trying to get excel to loop through the worksheets in the workbook and copy data to another workbook.

eg.
Task of each loop:
Find the sheet in the destination workbook with which sheet name matches the Value of cell C9

Copy data from Source Worksheet to destination worksheet

Move to next worksheet in source workbook and repeat loop.

So depending on the value of C9 on each worksheet in source with dictate the sheet that received the data in the source...

I have had a bash at some code which I will post below, but I cant get it work just right. Possibly because the Source Workbook file name can be variable!

HELP please....

Please Login or Register  to view this content.

Something like this maybe:

Please Login or Register  to view this content.

Dom

Aye, it would. I think I was getting a bit confused about what your code was doing as well so the example above probably doesn't make much sense.

Please Login or Register  to view this content.

The above example shows how to assign a workbook to an object and then look through the worksheets in that book. The copy doesn't really do anything but hopefully you'll get the drift.

Dom