| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
auto copy to new worksheet
I have made a worksheet containing a a large number of products (product
list) and want to automatically populate another worksheet (order sheet)when the quantity column has a number. for example: sheet 1 a:1 a:2 a:3 xyz 2 $9.95 so that when a:2 (the quantity column) =1, the cooresponding info goes to the order sheet. Any ideas would be appreciated -- regards, Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto copy down depending on criteria | Excel Worksheet Functions | |||
| Can not copy a worksheet to another workbook | Excel Discussion (Misc queries) | |||
| Copy from one worksheet to another | Excel Discussion (Misc queries) | |||
| How to Copy a Password Protected Excel Worksheet | Excel Worksheet Functions | |||
| how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Threaded Mode
