Closed Thread
Results 1 to 4 of 4

Formula to populate/copy data from one page to another in specific cells based on value of

  1. #1
    Registered User
    Join Date
    08-19-2014
    Location
    Orlando, FL
    MS-Off Ver
    MS Office Excel 2010
    Posts
    6

    Formula to populate/copy data from one page to another in specific cells based on value of

    I am trying to create a spreadsheet where there is contact information on page 1 in multiple cells that I would like to have populated into specific cells on page 2 if a specific cell on page 1 has a specific value. I run a baseball league with different teams. I have all the players in the league on page 1 along with their date of birth, their gender and a team they are assigned to (which is a drop down list to select from). My goal is to select the team a player is assigned to and then once I assign the team it will then auto populate some of that players information from page 1 into the cells allotted on page 2 where that teams information is collected. I will also need to know how to make it so as I am selecting teams for players and it is populating into the cells on page 2 that it (excel) knows to look for the next available line.

    hope you can help. this is driving me crazy. Thanks!

  2. #2
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Formula to populate/copy data from one page to another in specific cells based on valu

    please post an example workbook for more assistance.
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    08-19-2014
    Location
    Orlando, FL
    MS-Off Ver
    MS Office Excel 2010
    Posts
    6

    Re: Formula to populate/copy data from one page to another in specific cells based on valu

    See attached. 2014 Fall OBR Tee-ball Spreadsheet EXAMPLE.xlsx

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,751

    Re: Formula to populate/copy data from one page to another in specific cells based on valu

    Closed by request of kgrhomestony so it can be re-opened in Commercial Services.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to populate to specific cells based on cirteria
    By huard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2014, 07:41 AM
  2. [SOLVED] lookup a range of cells and populate specific cells based on matching data
    By RobertM01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-23-2014, 08:18 PM
  3. [SOLVED] Macro to copy specific data from one WB to specific cells in another WB based on specific
    By d_rose in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2014, 11:05 AM
  4. Replies: 5
    Last Post: 10-15-2012, 06:33 PM

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