+ Reply to Thread
Results 1 to 3 of 3

Auto populating data

  1. #1
    Registered User
    Join Date
    10-11-2011
    Location
    Walton Ky
    MS-Off Ver
    Excel 2007
    Posts
    1

    Auto populating data

    how can I type a number in 1 cell to populate into 2 others on another sheet within the same wookbook. I need to do this with several cells and I need it to do this everytime I change the number in the first cell.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Auto populating data

    Hi,

    It's not exactly clear what you're wanting. Trivially you could just link the two cells to the first cell with an =A1 formula.
    If it's something more than that then upload your example and manually add the results you expect to see and tell us which cells they are.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Auto populating data

    Hi gmill428
    Take a look at this Thread...sounds like what you're trying to do...
    http://www.excelforum.com/excel-prog...ple-cells.html
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1