PDA

View Full Version : show me the way to the next ...



white_flag
08-24-2010, 03:13 AM
Hello
I have to make some unitary prices based on an catalog prices and after that, the rest that will follow by adding values.
The prices are for pipes (Inox, Galvanized, Zinc ...) and has one row (or column) that will indicate Diameters and Thicknesses of the pipes:

______________Diameters |21|27|32|42| etc ....
thicknesses
1 ______________________data 1a,data 1b ..etc
2 ______________________data 2a,data 2b ..etc
3 ______________________data 3a,data 3b ..etc
4
etc

on this table will be add via an userform routine extra values like: painting, supports for montage, etc.
I use comboboxes for pipes (Inox, Galva ..etc) and for paint, supports etc ..I use text boxes. All data will be putted in an new sheeet with all the option selected via userform.

the equation that will take the date from datasheet it is made via

Range(A1:Y11).new sheet = Index(data(combobox.text), match(diameter), match(tk),1) + text.box1.value ..etc

tables with data are named dynamic range (ex. table with Inox value it is named "Inox", and so one)

so the selection it is done like this: Combobox.text(dinamic range) + textboxes1+textboxes2... = new.sheet with option selected


can you tell me if the idea is good or it is better something else?

thx