Forum Discussion
Formula Help
I have a spreadsheet I use for bidding construction work. On items 1-40 the formula in cells G22-G65 work like they are supposed to. From G66 to G88 where the sheet stops, the formula returns #NAME?....
I want to thank Olufemi7, m_tarler, and NikolinoDM for your help with this. I got into the Name Manager, and none of the sheets I was having a problem with were listed. I deleted sheet '41', and then copied sheet 40 to see what would happen. Sheet 41 showed up in the name manager. After renaming them and correcting a few formulas to look for the correct sheets, I'm happy to report they are all working like they should. Thanks again everyone!