If you just wanted to copy the data from the Quote sheet over to the
Order sheet, use IF formulas to create a cell reference.

For example if you had a sheet named 'Quotes' and another sheet named
'Orders', this formula placed in cell A1 of the Orders worksheet would
check the value of A1 of the Quotes worksheet; if it equaled "Y", it
pulls the value from A2 of the Quotes worksheet; otherwise it remains
blank.

=IF(Quotes!A1="Y",Quotes!A2,"")

Check out http://office.microsoft.com/en-us/ex...023431033.aspx
for more info on creating cell references.


Otherwise you would need to post some sample data for further
assistance.

HTH,

JP

On Jan 22, 3:57*pm, Veronica Johnson wrote:
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.