any way to check if a cell with perticular text is in the same pla
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? |
any way to check if a cell with perticular text is in the same pla
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? |
All times are GMT +1. The time now is 08:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com