I am not sure how to communicate what I am trying to ask, so please bear with
me. I have two sheets in a estimating workbook. Sheet one is the worksheet,
sheet two is the print out sheet for customers. In one cell on the print out
sheet I want one of two things to show up. In the worksheet, the two things
are in two seperate cells, and to select them you would have to input how
many of each in a seperate cell next to them. A simple IF function won't work
for what I need. Please let me know if you can help. Thank you very much.

Hi Kile

You'll have to be a lot more specific!
--
ve_2nd_at. Stilfontein, Northwest, South Africa


"Kile" wrote:

I am not sure how to communicate what I am trying to ask, so please bear with
me. I have two sheets in a estimating workbook. Sheet one is the worksheet,
sheet two is the print out sheet for customers. In one cell on the print out
sheet I want one of two things to show up. In the worksheet, the two things
are in two seperate cells, and to select them you would have to input how
many of each in a seperate cell next to them. A simple IF function won't work
for what I need. Please let me know if you can help. Thank you very much.

Bit vague, I'm afraid, but have you tried getting the information you want to
actually appear on the working sheet (sheet1 ?) - anywhere - and then putting
a "equals-link" from THAT data or cell(s) in the correct location in the
customer/printed sheet (sheet 2)?
Hope that might help
--
mac


"Kile" wrote:

I am not sure how to communicate what I am trying to ask, so please bear with
me. I have two sheets in a estimating workbook. Sheet one is the worksheet,
sheet two is the print out sheet for customers. In one cell on the print out
sheet I want one of two things to show up. In the worksheet, the two things
are in two seperate cells, and to select them you would have to input how
many of each in a seperate cell next to them. A simple IF function won't work
for what I need. Please let me know if you can help. Thank you very much.