multiple sheets, need help please

K

Kile

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.
 
M

mac@bath

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
 
R

Richard9278

Kile,

What would the criteria be for which item appeared in the printout?
Should it only pick the item in the worksheet that had a quantit
indicated in the adjacent cell? Your question implies that you don'
want to have to input the quantity in the worksheet. Is that correct?

Richar
 
Top