V
Veronica Johnson
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 created a column on the "Quote" sheet which is
entitled "ORDERED?". If there is a "Y" in the cell, then I want
columns B, C, D, and G in that particular row of the "Quote" sheet to
populate corresponding cells in the "Order" sheet. For instance, if
there is a Y in A10, I want B2, C2, D2, and G2 on the Quote worksheet
to populate cells A15, C15, D15, and E15 on the Order worksheet.
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. I also want all the
data bunched neatly at the top of the Order worksheet, so the IF
statement I tried did not work properly for this. 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.
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 created a column on the "Quote" sheet which is
entitled "ORDERED?". If there is a "Y" in the cell, then I want
columns B, C, D, and G in that particular row of the "Quote" sheet to
populate corresponding cells in the "Order" sheet. For instance, if
there is a Y in A10, I want B2, C2, D2, and G2 on the Quote worksheet
to populate cells A15, C15, D15, and E15 on the Order worksheet.
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. I also want all the
data bunched neatly at the top of the Order worksheet, so the IF
statement I tried did not work properly for this. 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.