G
Guest
I have a price list that utilizes several dropdown boxes (via data
validation) and vlookup values. when all is said and done, I end up with a
list with a customer name, phone number, and a varied combination of options
in various sections of the worksheet, but definately in nice linear rows. My
desire is to be able to develop some method, whether through VBA or macros to
collect each option, assign it the same customer identifier and bid number
(also to be generated) and export this into an access database.
Hopefully the following example clarifies my ramblings.
customer: Smith
phone: 1234567
date: 28-August
option 1: widget blue $1.29
option 2: widget red $1.29
option 3: hoohah black $4.00
option 4: [empty]
Export Data and append to an Access table.........
custID Date Bid# item color price
1 8/28/06 200 widget blue 1.29
1 8/28/06 200 widget red 1.29
1 8/28/06 200 hoohah black 4.00
Am I dreaming??
Thanks, Brian
validation) and vlookup values. when all is said and done, I end up with a
list with a customer name, phone number, and a varied combination of options
in various sections of the worksheet, but definately in nice linear rows. My
desire is to be able to develop some method, whether through VBA or macros to
collect each option, assign it the same customer identifier and bid number
(also to be generated) and export this into an access database.
Hopefully the following example clarifies my ramblings.
customer: Smith
phone: 1234567
date: 28-August
option 1: widget blue $1.29
option 2: widget red $1.29
option 3: hoohah black $4.00
option 4: [empty]
Export Data and append to an Access table.........
custID Date Bid# item color price
1 8/28/06 200 widget blue 1.29
1 8/28/06 200 widget red 1.29
1 8/28/06 200 hoohah black 4.00
Am I dreaming??
Thanks, Brian