We help IT Professionals succeed at work.
Get Started

MS Excel 2010 Goal Seek VBA + Function help

339 Views
Last Modified: 2016-02-11
Hello Gurus,
I have two problem that I need help solving...
Problem 1:
I have a workbook with two tabs (Matrix / Data). I need help writing vba to perform goalseek automatically once values are pasted into A,B,C,D,E sections under all periods. The goalseek value will appear under the More A's section only if it falls under 90%.
Most of the Data tab (A,B,C,D,E) values are filled in (periods 2-13 in to with conditions) so you can visually see what rows need to be calculated.  The numbers for ABCDE will always change so the VBA Needs to look at the  New% column and determine if values fall below the 90%.  Also, if the number returned for example is .13457332... this needs to be a positive number out 6 decimal places.. 1.345733
Problem 2:
Once the values are determined in the data tab, I will need a function to retrieve the number of More A's needed (By period and area).  Hope I have explained the requirements properly.  If you have any questions, please let me know.

Please see attached example workbook.
Example123.xlsx
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE