Hello all,

I have an excel file that contains multiple worksheets that acts as a
catalogue. What I would like to do is use and if/then statement that examines
the quantity column and if a value is entered it copies the entire row
contents onto another sheet called "Order Form". How is this done?

Thanks.

Have you tried using Vlookups?
Make the order form cells respond to whatever has been placed in the
catalogue quantity field by product? Have I missed the point here?


Claris =]

"Matt" wrote:

Hello all,

I have an excel file that contains multiple worksheets that acts as a
catalogue. What I would like to do is use and if/then statement that examines
the quantity column and if a value is entered it copies the entire row
contents onto another sheet called "Order Form". How is this done?

Thanks.