Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to perform a "where used"?
Hello. Thank you all in advance for your help.
The task I am trying to do is to perform a "where used" check. By "where used", I mean that I want my workbook to do a check of every worksheet in the workbook and report (put the sheet name(s) in a cell) any worksheet where a specific cell is used. In other words: In a worksheet called "data", I have a set of values in column A. The values from worksheet "data" are used to varying degree, by hyperlink, in other sheets(worksheets X1,X2,X3, etc). The value in sheet data, cell A1 might only be used in X1, but cell A2 might be used in sheet X2, X3, X10) As I mentioned, what i want is for a way to automatically output in one cell which sheets cell A1 is used, and in another cell output where cell A2 is used, etc. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to perform Search and Replace on "Tilde", CHAR(126), ~ | Excel Worksheet Functions | |||
%1 appears in "Application used to perform action" when trying to edit a file type | Excel Worksheet Functions | |||
Perform a "Conditional Substitute/Replace" | Excel Worksheet Functions | |||
How to perform "ifcount" in many sheets | Excel Discussion (Misc queries) | |||
How to perform "ifcount" in many sheets | Setting up and Configuration of Excel |