Automate goal seek in excel using vba or macro

Cancelled Posted Dec 12, 2015 Paid on delivery
Cancelled Paid on delivery

I have an excel sheet with a column of values (say column A). I then have an equation that I want to solve for the value in column A.

I can do this using "goal seek", but it is too slow with a column full of data. I need an automated solution.

These look useful:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

Excel Software Architecture Visual Basic for Apps

Project ID: #9106018

About the project

16 proposals Remote project Active Dec 13, 2015

16 freelancers are bidding on average $24 for this job

cgullapalli

Hi, I am good at excel and macros. Looking forward to work on this project. Plz provide me the excel sheet.

$20 USD in 0 days
(509 Reviews)
7.5
ACMAuk

Hi, I am CIMA-UK having excellent hands-on experience in using advance excel and macros. Can you please let me take a look of the excel sheet? Awaiting your response, Cheers, AHK

$30 USD in 1 day
(134 Reviews)
6.5
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 260 projects. Please look at the feedback left by my employers to know more about my work. Wai More

$30 USD in 3 days
(148 Reviews)
6.4
katilinas

Hi!) I CAN do this job! Please, look at my portfolio!) Do You need a freelancer who can fulfill all your requirements? Do You need a fair and square price? So, Hire me!

$15 USD in 2 days
(95 Reviews)
5.9
zebracaro

I can do it for you quickly and exactly

$35 USD in 2 days
(73 Reviews)
5.7
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 50 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliv More

$30 USD in 1 day
(78 Reviews)
5.9
abdolah2014

HI I am an excel_vba expert and I can finish your project in less than an hour pm me ..............................................................................................

$45 USD in 0 days
(37 Reviews)
5.4
rumarahman

Hi, I can do the automation using Macro. I want to try it now And will finish it now, I hope. Please contact me, Sir. Thank you. Best Regards, Ruma A.

$15 USD in 0 days
(15 Reviews)
4.5
rajafaizan

Hi, My expertise lies quality service in time accordingly as desired. I have 5+ years experience. in MS Office & VB-A. Besides this my expertise in Presentations, Data Entries, Designing, PDF document, Google Spreadshe More

$25 USD in 1 day
(26 Reviews)
4.4
atifarzi

Automatic goal seek can solve the issue. But, If you want more speed, maybe using custom methods like Newton Raphson to achieve desired accuracy (2 decimal) is best. In case you prefer that, It will take 2-3 days.

$10 USD in 1 day
(15 Reviews)
4.0
hpnunz08

Hi. I am experienced when it comes to Data Entry and I gained positive feedback from my Manager as well. I have experiences in Sales and Marketing, Appointment Setting, Customer Service, Job Posting, Email handling an More

$30 USD in 1 day
(0 Reviews)
0.0
anshneetu

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
smelgark

I've been working with VBA on a daily basis for about two years. Wold love to work on this project; if accepted over the weekend, I can get it out to you in under an hour.

$20 USD in 1 day
(0 Reviews)
0.0
techsunny948

A proposal has not yet been provided

$10 USD in 1 day
(0 Reviews)
0.0
rzesquieres

I can create a macro sub procedure or a function to automate the process. I had similar tasks before and I was able to solve them using both solutions.

$20 USD in 2 days
(0 Reviews)
0.0