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

[Bronco Billy]

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]

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