I'm new @ this and have a most likely lameo Question.
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

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

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Ontario, Canada
    Posts
    337
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com