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

On Sat, 1 Mar 2008 16:53:29 -0800 (PST), (E-Mail Removed) wrote:

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

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

--

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


"Gord Dibben" <gorddibbATshawDOTca> wrote in message news:(E-Mail Removed)...
> 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
>
> On Sat, 1 Mar 2008 16:53:29 -0800 (PST), (E-Mail Removed) wrote:
>
>>
>>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
>

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

"Ron de Bruin" wrote:

> Maybe better to use this example in this situation
> http://www.rondebruin.nl/copy3.htm
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message news:(E-Mail Removed)...
> > 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
> >
> > On Sat, 1 Mar 2008 16:53:29 -0800 (PST), (E-Mail Removed) wrote:
> >
> >>
> >>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
> >
>