Copying from multiple worksheets

[Kevin J Prince]

Is there a quick way to actually grab cells C33 and F4 on each of the
worksheets and place them on a fresh worksheet in three columns (third
one would be the date from A3 & A9 ) Do I have to get into some form of
VBA to do this? Date form would be '3-May-2006 to 9-May-2006'
Or
Some way of automatically filling in the new worksheet every time the
information is entered on the Weekly sheet?
--
Kevin J Prince

[bgeier]

On your "destination" sheet use something similar to this:

in cell "A1" put the formula for the first sheet
=Sheet1!C33
in cell "B1"
=Sheet1!f4
in cell "C1"
=Sheet1!A3 & Sheet1!A9

then repeat for each sheet you need to retrieve the data from
cell "A2"
=Sheet2!c33
cell "B2"
=Sheet2!f4
cell "C1"
= Sheet2!A3 & Sheet!A9

repeat for each sheet

[Kevin J Prince]

Whoops, as I was redirected from another NG for asking the question
below.. Wrongly. It's all associated with my other current questions.

Thanks,
I think that means in real terms a 63 worksheet GRIN...
so that gives me another question...

Is there a quick way to actually grab cells C33 and F4 on each of the
worksheets and place them on a fresh worksheet in three columns (third
one would be the date from A3 & A9 ) Do I have to get into some form of
VBA to do this? Date form would be '3-May-2006 to 9-May-2006'
Or
Some way of automatically filling in the new worksheet every time the
information is entered on the Weekly sheet?

Just trying to make the whole thing simpler!

Regards Kevin



>Word can only use one sheet as the mailmerge data source. Therefore
you
>will need to add another sheet to the file and on it reference in a
column
>for each week, the cells C33 and F4 from the other 52 sheets and then
use
>that sheet as the data source for the mail merge.
>


In message <[email protected]>, Kevin J Prince
<[email protected]> writes
>Is there a quick way to actually grab cells C33 and F4 on each of the
>worksheets and place them on a fresh worksheet in three columns (third
>one would be the date from A3 & A9 ) Do I have to get into some form of
>VBA to do this? Date form would be '3-May-2006 to 9-May-2006'
>Or
>Some way of automatically filling in the new worksheet every time the
>information is entered on the Weekly sheet?

--
Kevin J Prince