multiple sheets, need help please

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

[Kassie]

Hi Kile

You'll have to be a lot more specific!
--
[email protected]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.

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

[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 quantity indicated in the adjacent cell? Your question implies that you don't want to have to input the quantity in the worksheet. Is that correct?

Richard