Excel Help Needed
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. |
Excel Help Needed
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. |
All times are GMT +1. The time now is 02:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com