Monthly Sales Peformance Report.xlsx
I have attached a sample of the worksheet I am trying to configure. I have 10 tables that have the exact same column headings for each sales region. I am trying to figure out how to set them up like a pivot table, so that you don't have to scroll down to view the tables. I want to have a drop down box where you can select the region, and the table will show up. Kind of like in pivot tables where you select a certain item, and the table shows that items data. I don't even know if this is possible, but would appreciate some help.
Bookmarks