Combine different worksheets

  • Thread starter Thread starter cwilkin1
  • Start date Start date
C

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
 
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
 
Back
Top