Automatically fill from sheet to sheet
 

Hi all,

I need a way of doing this, not sure how, and i haven't got ANY
experience in macros!

If I write a value in worksheet 1, A1, I need it to automatically
appear in worksheet 2, A1 - is there another way apart from


=worksheet1!A1
(in A1 of worksheet 2)

as this means having this formula in all the boxes it will apply
to...and the number if items in worksheet 1 A1 could be infinite!

ALSO, is there a way to have an automatic/default in say A3 if I type
something in A1? How would this be done?

Many thanks in advance,
Suzanne :)


--
sedonovan
------------------------------------------------------------------------
sedonovan's Profile: http://www.excelforum.com/member.php...o&userid=35626
View this thread: http://www.excelforum.com/showthread...hreadid=554447

Automatically fill from sheet to sheet
 

If you wanted all A1 cells on all the sheets in a WB to link to A1 of
Sheet1, you could do this in one shot by grouping the sheets.

Say you have 25 sheets.
Click in the tab of Sheet2,
Hold down <Shift, and click in the tab of Sheet25.

Those 24 sheets are now grouped together, where whatever you do to one is
done to all.
Click in A1 and enter an equal ( = ) sign,
Now click in the tab of Sheet1,
Click in A1 of Sheet1 and hit <Enter.
And you're done!

Now click in the Sheet1 tab again to *ungroup* your sheets.

Whatever you type in A1 of Sheet1 will now be displayed in A1 of *all* your
other 24 sheets.

Is that what you were looking for?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"sedonovan" wrote
in message ...

Hi all,

I need a way of doing this, not sure how, and i haven't got ANY
experience in macros!

If I write a value in worksheet 1, A1, I need it to automatically
appear in worksheet 2, A1 - is there another way apart from


=worksheet1!A1
(in A1 of worksheet 2)

as this means having this formula in all the boxes it will apply
to...and the number if items in worksheet 1 A1 could be infinite!

ALSO, is there a way to have an automatic/default in say A3 if I type
something in A1? How would this be done?

Many thanks in advance,
Suzanne :)


--
sedonovan
------------------------------------------------------------------------
sedonovan's Profile:
http://www.excelforum.com/member.php...o&userid=35626
View this thread: http://www.excelforum.com/showthread...hreadid=554447