Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Not sure if this is possible (Excel97)

    Is it possible to link a cell in Excel so that whatever data I enter into this cell can be automatically entered into a seperate worksheet in my workbook? Example: Sheet1 Cell A:1 and Sheet2 Cell A:1. When I type data in Sheet1 cell A:1 that data would be automatically place in Sheet2 cell A:1. Not sure if this is possible. Thanks for the help

  2. #2
    Star Lounger
    Join Date
    Jan 2001
    Location
    WNC USA
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Not sure if this is possible (Excel97)

    You can link the cell with a formula, such that when you enter data into the 1st worksheet .. it is referenced in the second. To do this ... go to the worksheet and cell you want to contain the data from the 1st worksheet. In the cell, type = ... click on the worksheet tab containing the data you want to reference, click on the correct cell you want the data from, then press enter. Now what ever you type into the first worksheet will appear in the second.

    Hope this helps .. Chance

Posting Permissions

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