Enginerd
05-26-2009, 09:11 AM
hello, I am trying to move data from one table to another based on user input. I have a cell marked Height where the user can enter any height they please and this table (there is alot more data in the actual table this is for berevities sake)
Height VAL1 VAL 2
0-15 .21 .23
20 .33 -.35
30 .45 .6
40 .75 .89
What i want to do is based on the user input I.E 36 Ft to have another table populate with the values up to the nearest lesser value ie the new table would look like this
Height VAL1 VAL 2
0-15 .21 .23
20 .33 -.35
30 .45 .6
Im not entirly sure how to code this into Visual Basic I am Using Excel 2007 with visual basic 6.5, ive done this with a crap load of if then statements already but i know smarter people then myself know a much better way to accomplish this... Any help would be greatly appreciated.
Height VAL1 VAL 2
0-15 .21 .23
20 .33 -.35
30 .45 .6
40 .75 .89
What i want to do is based on the user input I.E 36 Ft to have another table populate with the values up to the nearest lesser value ie the new table would look like this
Height VAL1 VAL 2
0-15 .21 .23
20 .33 -.35
30 .45 .6
Im not entirly sure how to code this into Visual Basic I am Using Excel 2007 with visual basic 6.5, ive done this with a crap load of if then statements already but i know smarter people then myself know a much better way to accomplish this... Any help would be greatly appreciated.