I'm new @ this and have a most likely lameo Question.

Bronco Billy · Mar 3rd, 2002, 07:00 PM

Is it possible (and simple) to have a data change on one sheet automatically change data on another sheet/work book.
Excel came with the used lap top I purchased and unfortunatley I have no book, so far I've managed to muddle through and get alot of my buss. stuff on it but if I could get this feature to work it would be fab!

Ziggy · Mar 3rd, 2002, 08:19 PM

copy the data you would like to see in the other sheet ( I assume it might be a summary). when you paste it, Right click and select "paste special" in the box that pops up, click "Paste LINK". Those cells you pasted will now be linked to each other.

Ziggy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 3rd, 2002, 07:00 PM	#1
Bronco Billy New Member Join Date: Mar 2002 Posts: 1	Is it possible (and simple) to have a data change on one sheet automatically change data on another sheet/work book. Excel came with the used lap top I purchased and unfortunatley I have no book, so far I've managed to muddle through and get alot of my buss. stuff on it but if I could get this feature to work it would be fab!

Mar 3rd, 2002, 08:19 PM	#2
Ziggy Board Regular Join Date: Feb 2002 Location: Ontario, Canada Posts: 326	copy the data you would like to see in the other sheet ( I assume it might be a summary). when you paste it, Right click and select "paste special" in the box that pops up, click "Paste LINK". Those cells you pasted will now be linked to each other. Ziggy