+ Reply to Thread
Results 1 to 3 of 3

Auto Populate Columns for data in another Tab

  1. #1
    Registered User
    Join Date
    09-06-2018
    Location
    California, USA
    MS-Off Ver
    Office 365
    Posts
    26

    Auto Populate Columns for data in another Tab

    Hello. First post on this forum. I'm trying to find the best way to auto-populate a spreadsheet and I thought this would be a good place to start. I'm trying to take a very large data table of information (Data starts on cell A4 on the tab I'm using) on Sales from a business and pare it down to send out to Department Heads to track how their individual teams are doing. Since there are multiple teams I would like to autopopulate a condensed version of the data table into based on a Dropdown cell (located in A1) and wasn't sure whether VBA/Macros or formulas were the best way to do it. In my template for the condensed table I have match the headers of the columns from the original data table I want to use. Each Salesperson information is on a different line I want to filter based on the the Department Head column using a dropdown. Attached is a screenshot of how I want it to look. Is there a Macro to bring the info according to each header or use an index formula linked to the original formula and drag down. Any help I can get will be much appreciated. Thanks!
    Attached Images Attached Images

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Auto Populate Columns for data in another Tab

    You would be better to attach a workbook showing what you are trying to achieve.

    Go Advanced -> Manage Attachments -> Upload.

    I'm not sure what you are trying to do, but why not just use a filter on Column B Department Head?

  3. #3
    Registered User
    Join Date
    09-06-2018
    Location
    California, USA
    MS-Off Ver
    Office 365
    Posts
    26

    Re: Auto Populate Columns for data in another Tab

    The dataworkbook with the info that I'm trying to condense is an extremely large file unfortunately I cannot upload. It's also a file that is constantly updated with new information and added rows so I'm not really allowed to manipulate that sheet much. This task of condensing it for sales is something I would have to do and update weekly and send out a different set a data to each of about 20 department heads so with the small size of my group I don't really have the bandwidth to have it filtered. Let me try to explain it a different way. I'm trying to see if there is a why to use another sheet to query the original data sheet and fill in all the appropriate rows if I select an entry of the dropdown box. For instance in the example pic I showed of what my ideal version would look like, if I selected "Peterson" in the drop down menu, it would query the original datasheet to pull in all the rows with "Peterson" in the Department heads column into my new condensed format sheet with matching info for the column headings I selected. Just trying to find a way to cut down time to build files. Let me know if that makes sense.

+ 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. [SOLVED] Assistance will using keywords to auto populate 3 columns. HELP :)
    By AceForSale in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-11-2016, 09:52 AM
  2. Using four columns to auto populate in a 5th column
    By Hubbs in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-10-2016, 05:39 AM
  3. [SOLVED] Macro to Auto-populate cells and columns based off of a Number
    By Cansa in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-06-2013, 05:59 PM
  4. Auto populate a third cell, based on data from two columns
    By 12ogboy78 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-25-2013, 02:21 AM
  5. Auto Populate Two Columns Based On Data Entered Into Another Column
    By aleenah in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2013, 08:37 PM
  6. How to auto-populate cells in other columns with the value in a cell
    By Excelrookie_1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-17-2012, 08:03 AM
  7. Replies: 3
    Last Post: 02-28-2012, 11:54 AM

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