Forum Discussion
Getting values from the same cell address in different spreadsheets
I have a spreadsheet with 25 tabs containing structured data (text and numbers) for 25 separate entities. I want to create a summary sheet for all 25 entities that references certain cells in each t...
The data are in different tabs (sheets) in my Excel workbook and sometimes they are at different cell addresses.
I'm not familiar with Excel Tables. Can you explain a bit further?
That same educational resource I sent you to earlier for info on INDIRECT can help you with questions like this on the nature of Excel Tables. https://exceljet.net/excel-tables
Spend some time there. Another good resource for getting more acquainted withe Excel is YouTube.