Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search for a particular cell in worksheets
I have 20 multiple worksheets - if I change a cell in B14 on the 1st
worksheet, how can I tell if it changed everywhere that it was referenced on each additional worksheet? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search for a particular cell in worksheets
Hi,
If that cell was correctly referenced in other formula/sheets and calculation is set to automatic then you can trust Excel to have done it, no need to check. Mike "JoviGirl" wrote: I have 20 multiple worksheets - if I change a cell in B14 on the 1st worksheet, how can I tell if it changed everywhere that it was referenced on each additional worksheet? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search for a particular cell in worksheets
You can search for the Sheet1 B14 value across all sheets.
Select "Workbook" in the editfind options. Or just make sure you have calculation set to automatic and trust Excel to make the changes where required. Gord Dibben MS Excel MVP On Wed, 14 Jan 2009 13:00:07 -0800, JoviGirl wrote: I have 20 multiple worksheets - if I change a cell in B14 on the 1st worksheet, how can I tell if it changed everywhere that it was referenced on each additional worksheet? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for duplicates across three worksheets | Excel Worksheet Functions | |||
Search in Multiple Worksheets | Excel Discussion (Misc queries) | |||
search worksheets | Excel Discussion (Misc queries) | |||
Search Multiple Worksheets | Excel Discussion (Misc queries) | |||
Search all worksheets in a workbook... | Excel Discussion (Misc queries) |