| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I need help with way to return 0 or N/A to a formula
that refers to a sheet that has been deleted. I have a set of spread sheets
that I use to do quotes. Each sheet refers back to one page to give you an over view of the totals from each sheet. When I don't use a sheet on a particular job I just delete that sheet/s but I get all those REF# that make the sheet hard to read. I can't add sheets because the quotes have links to a master price list in the same workbook! Marc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with a formula | Excel Discussion (Misc queries) | |||
| Cannot change a formula | Excel Discussion (Misc queries) | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
