Combine different worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cwilkin1@twcny.rr.com - 02 Mar 2008 00:53 GMT

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

Reply to this Message

Gord Dibben - 02 Mar 2008 01:09 GMT

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

>Hi, I am working with Excel 2003. I have separate worksheets in
>different workbooks, each sheet has various rows (from 80 to 800) and
[quoted text clipped - 6 lines]
> Thanks
> Chuck

Reply to this Message

Ron de Bruin - 02 Mar 2008 11:27 GMT

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

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> If cannot use VBA then you are pretty well stuck with the manual operation.
>
[quoted text clipped - 23 lines]
>> Thanks
>> Chuck

Reply to this Message

Cookie47 - 22 Apr 2008 15:59 GMT

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

> Maybe better to use this example in this situation
> http://www.rondebruin.nl/copy3.htm
[quoted text clipped - 26 lines]
> >> Thanks
> >> Chuck

Reply to this Message