Solograndma back with another complicated formula problem.
In my workbook I have a data entry sheet that transfers data to a printable
sheet. I have a copy and paste function with mid-range formulas for and
address as well as a manual entry area. I have the formula to use the pasted
information if it's there or the manually entered information if it is there.
What I need is for the cells in the printable page to be blank if both the
pasted and the manual entry areas are blank. Everything I have tried brings
back zeros and unfortunately this form nees to be able to be printed as a
blank form for hand written use. I truly appreciate any help available. This
message board has been great so far. Thanks.