Hi Everyone,
My current formula is INDIRECT("'" & $A8 & "'!b6"); A8 is referencing a worksheet name and B6 is the direct cell in that worksheet. Indirect works beautifully, until I have a ton of them and it's bogging my spreadsheet down. I need to find another way to return the specific cell (B6) from each worksheet within the workbook...without using VBA or an Array.
Any help would be appreciated!
Thanks,
Shelly
My current formula is INDIRECT("'" & $A8 & "'!b6"); A8 is referencing a worksheet name and B6 is the direct cell in that worksheet. Indirect works beautifully, until I have a ton of them and it's bogging my spreadsheet down. I need to find another way to return the specific cell (B6) from each worksheet within the workbook...without using VBA or an Array.
Any help would be appreciated!
Thanks,
Shelly