any way to check if a cell with perticular text is in the same pla

[Narnimar]

If I organize a large work book with multiple sheets for summing a cell value
it is tedious to go through each sheet. Is there any way to lookup and ensure
if a cell with perticular text is in the location or not?

 

[JLatham]

It can be done a couple of ways; you could do it with VBA code (a macro), or
you could set up a "cheat sheet" to peek at those cells to see what is in
them.

To set up a cheat sheet, just insert a new worksheet into the workbook and
then choose a cell and then
type the = symbol in it
choose one of the sheets you need to examine and then click the cell you
want to examine on it and press the [Enter] key.

Now what ever is in that cell will appear in the cell on your 'cheat sheet'.
You can set up cells for each of the cells on the other sheets you need to
review. Then all you have to do is look at your cheat sheet to see what's on
all of them.

Hope this helps some.