I have 2 worksheets in the same workbook. One worksheet is for the
price quote to the customer and has many rows, each item/price/
quantity in its own row. The other worksheet is for the actual order
sheet which the customer has purchased based on the quoted items.
However, the customer doesn't usually buy every item on the quote
sheet. So, what I've done is, I've created a column on the "Quote"
sheet which is entitled "ORDERED?". If there is a "Y" in the cell,
then I want some of the cells in that particular row of the "Quote"
sheet to populate corresponding cells in the "Order" sheet. However,
if there is a "N" in the cell, then I don't want any of the
information to be copied to the "Order" sheet. Is this possible?
I've tried to be as descriptive and as thorough as possible in my
explanation and any help would be greatly appreciated. Thank you so
much.