Good afternoon,
I'm trying to create a very simple order form, and would appreciate some assistance. It's been a while since I've done this in Excel, and I couldn't find an answer when I searched. (I may be a lousy searcher, though.)
I want the user to enter a quantity in Column E of the "Common Items" worksheet, and have all the rows with quantities copied to the "Order" worksheet. (On the "Order" copy below, I just did a copy/paste to show the desired effect.)
Excel 2007
<tbody>
</tbody>
Excel 2007
<tbody>
</tbody>
I'm pretty sure this can be accomplished with an If/Then, but I'm lost! Optimally, they'd enter their quantities, click on the Order sheet and hit print. Thanks in advance for your kind assistance and reply!
Nancy
I'm trying to create a very simple order form, and would appreciate some assistance. It's been a while since I've done this in Excel, and I couldn't find an answer when I searched. (I may be a lousy searcher, though.)
I want the user to enter a quantity in Column E of the "Common Items" worksheet, and have all the rows with quantities copied to the "Order" worksheet. (On the "Order" copy below, I just did a copy/paste to show the desired effect.)
Excel 2007
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Item Number | Description | Unit | Price | Qty | Total |
2 | BX-2B1324X | 0.9% NaCL 1000ml Bags | CS | $23.52 | 5 | $117.60 |
3 | AB-1966-07 | 0.9% NaCL 30ml MDV 25s | PK | $19.22 | 2 | $38.44 |
4 | KE-5150 | Alcohol Preps MED 200s | BX | $1.22 | $0.00 | |
5 | DY-1113 | Alcohol Preps MED STR 200s | BX | $1.30 | $0.00 | |
6 | NUT-99990 | Bandage Cloth 1x3 100s | BX | $2.73 | $0.00 | |
7 | NUT-99991 | Bandage Cloth 3/4x3 100s | EA | $6.08 | 2 | $12.16 |
8 | NUT-1595033 | Bandage Cloth Flexible | BX | $2.34 | $0.00 |
<tbody>
</tbody>
Common Items
Excel 2007
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Name: | |||||
2 | Deliver to: | |||||
3 | ||||||
4 | Item Number | Description | Unit | Price | Qty | Total |
5 | BX-2B1324X | 0.9% NaCL 1000ml Bags | CS | $23.52 | 5 | $117.60 |
6 | AB-1966-07 | 0.9% NaCL 30ml MDV 25s | PK | $19.22 | 2 | $38.44 |
7 | NUT-99991 | Bandage Cloth 3/4x3 100s | EA | $6.08 | 2 | $12.16 |
8 |
<tbody>
</tbody>
Order
I'm pretty sure this can be accomplished with an If/Then, but I'm lost! Optimally, they'd enter their quantities, click on the Order sheet and hit print. Thanks in advance for your kind assistance and reply!
Nancy
Last edited: