Hello guys
In my sheet formulas for interpolating some charts are working smooth and nice but i want to change an input based on a model of pump. Because simple index doesn't work well because after using formula in cell it is no longer empty and excel is trying to aprox. some strange values. I thought about vba and programmable button for copying certain rows just by pressing it.
The model of the pump is stored in row 2 column B, and the input values are in row 20 column C:BA, and my goal is to either change that input row by changing model in B2 alone or changing B2 + pressing the button - it depends what is easier because I never used VBA and that will be my first time. All informations will be stored in catalog in each row containing 2 pictures (some are simple icons to reduce size), model, company and input value. Also the range for search should be as long as it is possible because i do not know how many pumps i will have inside sheet.
Thank you for your help!
ASDG
Bookmarks