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 all of the names of each sheet (Q1, Q2, Q3, & Q4). I want the user to be able to select one of the quarters from the dropdown, and that Qtr's table contents be inserted into the invoice under the mailing information. I have successfully created each worksheet and the drop down is working. I just can't figure out how to display the data for the entire column in the master invoice, just the first row. I just can't figure out the best way to do the entire column. NOTE: the column will not have the same number of rows all the time so it needs to be fluid. There may be a cleaner way to do this, I just can't find info.
All of the quarter tables, Q1 - Q4 have the same formatting/layout as the data shown under the blue headings on the screenshot. This is how I did the formula to get those :
I was also wondering if there was a way to use the Insert Date - from sheet using the drop down and if that would be better but not sure if that would be the best approach. I am new to this type of workbook.
Thanks in advance! Let me know if it needs further explanation!
All of the quarter tables, Q1 - Q4 have the same formatting/layout as the data shown under the blue headings on the screenshot. This is how I did the formula to get those :
Excel Formula:
=INDIRECT("'"&$B$2&"'!B2")
Thanks in advance! Let me know if it needs further explanation!