Copying from multiple worksheets

K

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

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

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
 
Top