Welcome Guest
Log In | Register )
You last visited January 17, 2017, 12:05 pm
All times shown are
Eastern Time (GMT-5:00)

Excel

Topic closed. 2 replies. Last post 12 years ago by johnph77.

Page 1 of 1
PrintE-mailLink
Avatar
New Member
Burley
United Kingdom
Member #10979
February 1, 2005
1 Posts
Offline
Posted: February 1, 2005, 9:52 am - IP Logged

How can I add a cell (A2) in one worksheet to cell (B3) in another worksheet ?

    undress's avatar - Lottery-061.jpg
    roseville, MI
    United States
    Member #5980
    July 30, 2004
    18205 Posts
    Offline
    Posted: February 1, 2005, 10:43 am - IP Logged

    You have to link the to pages.

    email me what you have and a desription and I'll do it for you.

    Mad ALL IN!Mad

      johnph77's avatar - avatar
      CA
      United States
      Member #2987
      December 10, 2003
      832 Posts
      Offline
      Posted: February 1, 2005, 2:58 pm - IP Logged

      Moco -

      If the sheets are part of the same workbook you can transfer information from one cell on one sheet to another on another sheet with the formula:

      =A!A2

      to Cell B3 on the receiving sheet. Then every time the valus in A!A2 changes, the change will also be reflected in the receiving cell as well.

      gl

      j

      Blessed Saint Leibowitz, keep 'em dreamin' down there..... 

      Next week's convention for Psychics and Prognosticators has been cancelled due to unforeseen circumstances.

       =^.^=