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...
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.