MS Excel 2010 Goal Seek VBA + Function help

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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Excel amusantCommented:
Please find attached.

The macro will automatic will run whenever there is change in your table in data sheet.

The sheet Matrix will be updated based on the Period you select from drop down.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BajanPaulAuthor Commented:
Thanks again for your help!
Excel amusantCommented:
You welcome BajanPaul.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.