Finding Values in a Linked Cell

[Schlep22]

Hi everyone,

I have a workbook with 40 sheets, all of which are formatted the same. On my summary page I have totalled various cells by linking the corresponding cell from each worksheet.

My question is : if the summary page shows a value of say £1000, and this value came from just one of the worksheets (ie. one worksheet is £1000, all the rest are nil), is there a quick way of telling which sheet this figure has come from rather than clicking through all the links from the summary page on at a time!

Thanks for your help!!!

[Badger04]

Short answer is NO (Unless someone else has the answer), however depending on the structure of your workbook there are other ways that this can be achieved.