PDA

View Full Version : Using Solver with a macro



austenr
01-29-2020, 04:26 PM
At this point I’m just looking for some direction.

I download an excel workbook from our server. The headings and other useless stuff are always in the same place but the data I want to solve could be anywhere from A7 on down

I need to be able for the user to input the number to be solved for into an input box which isn’t a problem.

Im kinda stumped on how to make column A dynamic along with the multiplier.

the end result would be what numbers or combination of numbers make up the number the user inputs. These tend to be anywhere from 50-100 or more rows.

Any suggestions are appreciated.