P
patW
I have two sheets, sheet 1 is a order form and sheet 2 is the referenc
of products and prices.
Sheet1: http://cl.ly/2A1b280K3x0d0o1F3y3x
Sheet 2: http://cl.ly/1k1F3M0C2l3S1s2o1K3W
Sheet 1 has drop-downs for Color1, Color2, Charm1, Charm2 reference
from sheet 2.
How can I:
1. In sheet 1, how I can I have Group Number column populate with th
listed group # 0001 and an order number starting at 1 each time a choic
from Color1 drop down is selected.
i.e. 00001 1 Royal Blue
00001 2 Royal Blue
00001 3 Navy Blue
2. Also, after a choice is selected from Color1 drop down the Grou
Retail column is populated with the base price listed in sheet 2, o
$19.99
---AND---
3. When and/if additional Charm2 is selected, an additional $4.00 i
added to Group Retail column for that row.
Basically, I'd like a way to populate this order form with subsequen
order #'s (1-500) each time Color1 is selected from the table an
populate the Group Retail column with $19.99 until the additional Charm
(of $4.00) is added to the order making that rows Group retail tota
$23.99
Any help is appreciated.
Cheers, Pa
+-------------------------------------------------------------------
+-------------------------------------------------------------------
of products and prices.
Sheet1: http://cl.ly/2A1b280K3x0d0o1F3y3x
Sheet 2: http://cl.ly/1k1F3M0C2l3S1s2o1K3W
Sheet 1 has drop-downs for Color1, Color2, Charm1, Charm2 reference
from sheet 2.
How can I:
1. In sheet 1, how I can I have Group Number column populate with th
listed group # 0001 and an order number starting at 1 each time a choic
from Color1 drop down is selected.
i.e. 00001 1 Royal Blue
00001 2 Royal Blue
00001 3 Navy Blue
2. Also, after a choice is selected from Color1 drop down the Grou
Retail column is populated with the base price listed in sheet 2, o
$19.99
---AND---
3. When and/if additional Charm2 is selected, an additional $4.00 i
added to Group Retail column for that row.
Basically, I'd like a way to populate this order form with subsequen
order #'s (1-500) each time Color1 is selected from the table an
populate the Group Retail column with $19.99 until the additional Charm
(of $4.00) is added to the order making that rows Group retail tota
$23.99
Any help is appreciated.
Cheers, Pa
+-------------------------------------------------------------------
+-------------------------------------------------------------------