MY question is this:
In my spreadsheet I have individual worksheets - The colours of individual tabs are determined by specific scenarios.
I would like in my index sheet in column G to have a formula to list out whatever colour the tab is in the individual sheets.
I am using the Indirect formula to look at data for example:
=INDIRECT("'"&A7&"'!$D$62") This formula looks up data on my index sheet and links to individual tabs to pull in data from selected cells.
Thanks
In my spreadsheet I have individual worksheets - The colours of individual tabs are determined by specific scenarios.
I would like in my index sheet in column G to have a formula to list out whatever colour the tab is in the individual sheets.
I am using the Indirect formula to look at data for example:
=INDIRECT("'"&A7&"'!$D$62") This formula looks up data on my index sheet and links to individual tabs to pull in data from selected cells.
Thanks