Automate goal seek in excel using vba or macro

Анульовано Опубліковано %project.relative_time Оплачується при отриманні
Анульовано Оплачується при отриманні

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 Архітектура ПЗ Visual Basic для додатків

ID Проекту: #9106018

Про проект

16 заявок(-ки) Дистанційний проект Остання активність Dec 13, 2015

16 фрілансерів(-и) готові виконати цю роботу у середньому за $24

cgullapalli

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

$20 USD за 0 дні(-в)
(509 відгуків(и))
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 за 1 день
(134 відгуків(и))
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 Більше

$30 USD за 3 дні(-в)
(148 відгуків(и))
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 за 2 дні(-в)
(95 відгуків(и))
5.9
zebracaro

I can do it for you quickly and exactly

$35 USD за 2 дні(-в)
(73 відгуків(и))
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 Більше

$30 USD за 1 день
(78 відгуків(и))
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 за 0 дні(-в)
(37 відгуків(и))
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 за 0 дні(-в)
(15 відгуків(и))
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 Більше

$25 USD за 1 день
(26 відгуків(и))
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 за 1 день
(15 відгуків(и))
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 Більше

$30 USD за 1 день
(0 відгуків(и))
0.0
anshneetu

A proposal has not yet been provided

$25 USD за 1 день
(0 відгуків(и))
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 за 1 день
(0 відгуків(и))
0.0
techsunny948

A proposal has not yet been provided

$10 USD за 1 день
(0 відгуків(и))
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 за 2 дні(-в)
(0 відгуків(и))
0.0