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