Forum Discussion
Insert table data from one of 4 sheets into master invoice based on dropdown choice
I am using Excel 2016. I have a master invoice I have created, and we have 4 sheets of data, 1 sheet per quarter where assets are to be tracked. On the master sheet I have created a drop down with a...
Try "Filter" formula if it is available with "Sort". I have used it to populate a list for each main header having multiple and different count of sub branches. It works fine. I just started using it recently.
- Right now the headers on the master invoice are just text. So I assume I would change those text headers to a formula that somehow references the sheet that the user has chosen from the drop down? Trying to picture what Filter/Sort would do in this scenario. I want the entire table to insert for a particular quarter that is chosen.
- I took the whole data and referred it to a cell which has list/dropdown and it reflects all the column in front of the selection from original data
- I don't know what to use to accomplish that. I am assume you are using INDIRECT somewhere to reference the dropdown cell, but from there I don't know how you would refer the whole data to the column in the Master Invoice sheet.
