"cac1966" wrote:
One more question....when I copy this formula and there is not a purchase
order made for it yet, it returns a #ref! error.
Yup, that's as stated in my earlier response to you on 13 Mar
Of course, any new sheetnames that don't exist as yet will return #REF
I want to hide this on the ledger.
I tried conditional formatting and white out the word but it didnt
work. I have a column of #ref! now is there anything I can do to hide these
until the Purchase order has been entered?
Use ISERROR to mask in CF ..
Try it like this, to apply it all at one go:
Select the entire col B (B1 active)
Click Format Conditional Formatting
Under Condition 1, make the settings as:
Formula is: =ISERROR(B1)
Format the font as white, Ok out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---