Combine different worksheets

[cwilkin1]

Hi, I am working with Excel 2003. I have separate worksheets in
different workbooks, each sheet has various rows (from 80 to 800) and
all sheets only use 3 columns.I only use one sheet in each workbook.
I want to make a summary sheet every 4 weeks which will have all the
information from the four sheets. At the present time I'm copying and
pasting it as I want to keep the original weekly sheets. Is there an
easier way to do this? I do not know Visual Basic.

Thanks
Chuck

 

[Gord Dibben]

If cannot use VBA then you are pretty well stuck with the manual operation.

As you get into more advanced usage in Excel you will find that VBA might be the
ONLY way you can do something.

Have a look at Ron de Bruin's site for code and instructions for copying from
multiple workbooks to a single workbook.

http://www.rondebruin.nl/summary2.htm

Read it over and copy the code to experiment with.

Enjoy but remember to make a few good backups before starting upon the VBA
voyage.


Gord Dibben MS Excel MVP

 

[Ron de Bruin]

Maybe better to use this example in this situation
http://www.rondebruin.nl/copy3.htm

 

[Cookie47]

Fantastic bit of coding, you've just saved me a load of work, many thanks!!