Creating order form in Excel 2007; Need to copy entire row if one cell has data

[moonpie71]

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

	A	B	C	D	E	F
BX-2B1324X	0.9% NaCL 1000ml Bags
AB-1966-07	0.9% NaCL 30ml MDV 25s
KE-5150	Alcohol Preps MED 200s
DY-1113	Alcohol Preps MED STR 200s
NUT-99990	Bandage Cloth 1x3 100s
NUT-99991	Bandage Cloth 3/4x3 100s
NUT-1595033	Bandage Cloth Flexible

<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Item Number[/TD]
[TD="align: center"]Description[/TD]
[TD="align: center"]Unit[/TD]
[TD="align: center"]Price[/TD]
[TD="align: center"]Qty[/TD]
[TD="align: center"]Total[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]CS[/TD]
[TD="align: right"]$23.52[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"]$117.60[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]PK[/TD]
[TD="align: right"]$19.22[/TD]
[TD="align: center"]2[/TD]
[TD="align: right"]$38.44[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]BX[/TD]
[TD="align: right"]$1.22[/TD]
[TD="align: center"][/TD]
[TD="align: right"]$0.00[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]BX[/TD]
[TD="align: right"]$1.30[/TD]
[TD="align: center"][/TD]
[TD="align: right"]$0.00[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]BX[/TD]
[TD="align: right"]$2.73[/TD]
[TD="align: center"][/TD]
[TD="align: right"]$0.00[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]EA[/TD]
[TD="align: right"]$6.08[/TD]
[TD="align: center"]2[/TD]
[TD="align: right"]$12.16[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]BX[/TD]
[TD="align: right"]$2.34[/TD]
[TD="align: center"][/TD]
[TD="align: right"]$0.00[/TD]

</tbody>

Common Items​

Excel 2007

	A	B	C	D	E	F
Name:
Deliver to:
BX-2B1324X	0.9% NaCL 1000ml Bags
AB-1966-07	0.9% NaCL 30ml MDV 25s
NUT-99991	Bandage Cloth 3/4x3 100s

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]Item Number[/TD]
[TD="align: center"]Description[/TD]
[TD="align: center"]Unit[/TD]
[TD="align: center"]Price[/TD]
[TD="align: center"]Qty[/TD]
[TD="align: center"]Total[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]CS[/TD]
[TD="align: right"]$23.52[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"]$117.60[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]PK[/TD]
[TD="align: right"]$19.22[/TD]
[TD="align: center"]2[/TD]
[TD="align: right"]$38.44[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]EA[/TD]
[TD="align: right"]$6.08[/TD]
[TD="align: center"]2[/TD]
[TD="align: right"]$12.16[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</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

 

[Skybluekid]

I have had a look at your file and I am a little lost about what you are trying to achieve

 

[morganita]

Let's say when one of the items is out of stock I make a note of that item what I have to order in the 'registration sheet'. The purpose of the 'registration sheet' is for my annual report of purchase. Every item I want to buy and make a note of it in the 'registration sheet' I want it simultaneously to generate a purchase order form for the company where I can buy these items. I hope this explanation will help.

 

[Skybluekid]

What version of excel are you using?

 

[morganita]

Depends on the pc where I work. 2007 and 2013