+ Reply to Thread
Results 1 to 4 of 4

Autopopulate items from one sheet to another based off list selection.

  1. #1
    Registered User
    Join Date
    09-03-2015
    Location
    Honolulu, Hawaii
    MS-Off Ver
    2010
    Posts
    2

    Autopopulate items from one sheet to another based off list selection.

    I am creating an Excel document where I need to track 8 different types of reports. I have created a main sheet where each column lists an individual report in order of date/time. In each corresponding horizontal column there is a dropdown menu where I can select which of the 8 reports the data is referring to in that column.

    I then created 8 additional sheets with each sheet dedicated to one of the 8 report types.

    When I select the report type in the pull-down on the main sheet I'm looking for the data entered in that column, for that report, to populate to the sheet corresponding to that report type.

    So basically, If I have a pull-down referencing each report type in column A3 and data relevant to that report from B3-F3. How do I get the data entered in B3-F3 to populate to the correct sheet based on the pull-down choice from A3?

    I've attached the file as well. Thanks everyone.Reporting Log Help.xlsx

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Autopopulate items from one sheet to another based off list selection.

    This is 1 of the possibility


    Kind regards
    Leo
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-03-2015
    Location
    Honolulu, Hawaii
    MS-Off Ver
    2010
    Posts
    2

    Re: Autopopulate items from one sheet to another based off list selection.

    Thank you Leo.

    I do need to make a few revisions because not all the sheets are identical. Can you please try and explain to me how you accomplished this? Thanks again.

  4. #4
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Autopopulate items from one sheet to another based off list selection.

    If not all the sheets are identical, you need another code
    this one only works with identical sheets.


    Kind regards
    Leo

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. show a list of items based on combo box selection
    By zak.horrocks in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2014, 06:14 AM
  2. [SOLVED] Moving items between sheet based on a selection
    By Mr_Bill in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-25-2014, 05:24 PM
  3. Items that Autopopulate on seperate Sheet in list form when selected.
    By Mccorkle123 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 06-23-2014, 02:16 PM
  4. Autopopulate multiple columns based on dropdown selection in far left column
    By tinaascoggins in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-02-2014, 12:29 PM
  5. Replies: 3
    Last Post: 01-22-2013, 01:13 AM
  6. Autopopulate a List based on tab names
    By toddjesus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2012, 06:15 PM
  7. list of names in one sheet autopopulate in another?
    By Jim Cronin in forum Excel General
    Replies: 2
    Last Post: 09-04-2012, 04:22 PM

Tags for this Thread

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