jcountry22
New Member
- Joined
- Aug 15, 2014
- Messages
- 36
I am looking for a way to search for a cell value that may be embedded in a formula in a worksheet.
Example:
Worksheet contains tabs/sheet A-Z (26 different Sheets with data). Formulas amongst the various tabs are pulling from one another, without any circular references.
Sheet J in cell S150 contains a value (say $250), that is a sum calculation of 3 numbers above it + Sheet Q, Cell S150.
Is it possible to easily search the workbook to see if any other formula within the worksheet references the value on Sheet J cell S150?
Example:
Worksheet contains tabs/sheet A-Z (26 different Sheets with data). Formulas amongst the various tabs are pulling from one another, without any circular references.
Sheet J in cell S150 contains a value (say $250), that is a sum calculation of 3 numbers above it + Sheet Q, Cell S150.
Is it possible to easily search the workbook to see if any other formula within the worksheet references the value on Sheet J cell S150?
