Hello,
Asking for anyone who can offer any suggestions in being able to auto expand a table based on data added to cells next to it , if possible.
In our example. we are bringing over data from a report by using power query that is mashing together all of our data and placing the data based on the call center and exporting the new table created into another workbook to its corresponding call center sheet name. This information is then being used as a lookup to other files in a table directly next to it and contains formulas. So the question is, once the new data is queried in and dumped into the sheet... how can I have our other table with formulas to expand its rows based on the number of rows that is in the table that was queried in from power query.
If there are any links or examples to use, it would be appreciated.
Maybe a helper column but I have looked around for awhile now.
I have attached a sample workbook with a basic mock up of how my data is being used. (There are 90 centers so there will be 90 sheets with the same layout)
Thanks,
Ant
Bookmarks