Forum Discussion
Automate Master Sheet
I have a workbook that contains 9 worksheets plus a Master sheet, all have tables I need the data from the 9 worksheets to update the Master sheet without using vba or macros. I used the vlookup form...
If you are able to share either the actual workbook or a facsimile (not an image, an Excel workbook with false data), it would be a LOT easier to see exactly what you're working with.
If you're not able to do that, a question and suggestion:
- Are the 9 worksheets laid out in the same fashion? If so, you might find the INDIRECT function helpful -- I use it in a similar situation, to extract data from subordinate sheets to a summary master, where all of the subordinates are arrayed similarly.
- Here's a useful reference on INDIRECT: https://exceljet.net/excel-functions/excel-indirect-function