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
|