Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. "Narnimar" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do you match data and paste result in a perticular cell? | Excel Worksheet Functions | |||
How do i set up blink a perticular cell? | Excel Discussion (Misc queries) | |||
How to set text property of a check box to value of a cell? | Charts and Charting in Excel | |||
'CHECK IF A CELL IN EXCEL HAS ANY TEXT IN IT' | Excel Worksheet Functions | |||
Check if cell contains certain text | Excel Worksheet Functions |