szesz
04-01-2016, 07:11 AM
Hi!
I have a long database of machines (with codes, short names, types, and price) from which the customers can order these machines, and I'd like to do the following:
ask the consumer about the type of machine and the price RANGE he wants to choose from (there are several products but I only want to offer the user to choose from prod. A or prod. B)
list the consumer's choices into an array (containing the codes, short names, types, price of the possibilities)
create a new sheet containing these choices which contain the results in an increasing order based on the price
Could someone give me some useful methodologies to solve this? I could do some bits and smaller things but I am stuck with the stuff I wrote above :/ I've never done anything similar using VBA before. I hope I explained the problem clearly. Any help is appreciated, thanks in advance!
I have a long database of machines (with codes, short names, types, and price) from which the customers can order these machines, and I'd like to do the following:
ask the consumer about the type of machine and the price RANGE he wants to choose from (there are several products but I only want to offer the user to choose from prod. A or prod. B)
list the consumer's choices into an array (containing the codes, short names, types, price of the possibilities)
create a new sheet containing these choices which contain the results in an increasing order based on the price
Could someone give me some useful methodologies to solve this? I could do some bits and smaller things but I am stuck with the stuff I wrote above :/ I've never done anything similar using VBA before. I hope I explained the problem clearly. Any help is appreciated, thanks in advance!