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!
Bookmarks