convert Excel, with Macros, to Google sheets.

Trying to convert Excel, with Macros, to Google sheets.

I can’t find a GoalSeek Equivalent in Sheets .

Sub Calculate()

Sheets("Amort").Range("N22").Offset(rowOffset:=Sheets("Amort").Range("J5").Value, columnOffset:=0).GoalSeek Goal:=0, ChangingCell:=Sheets("Amort").Range("P10")

Sheets("Amort").Range("W22").Offset(rowOffset:=Sheets("Amort").Range("J5").Value, columnOffset:=0).GoalSeek Goal:=0, ChangingCell:=Sheets("Amort").Range("P12")

Sheets("Amort").Range("AY22").Offset(rowOffset:=Sheets("Amort").Range("J5").Value, columnOffset:=0).GoalSeek Goal:=0, ChangingCell:=Sheets("Amort").Range("P14")

End Sub
Steve HarrisAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Roy CoxGroup Finance ManagerCommented:
I can't understand why you would want to do this. Google Sheets and Open Office are not compatible with Excel  when it comes to macros. IMO Excel is far superior. here's a guide that might help

Google Sheets Macros
0
Steve HarrisAuthor Commented:
Roy
This Sheet is a 'Special Financial Calculator' which is being used by an existing Sheets.

Sheets does not have a 'GoalSeek'.

Also, as an aside:

(Note: Google Sheets macros are currently being rolled out, and should be available to all users within the next few weeks.)
0
Roy CoxGroup Finance ManagerCommented:
(Note: Google Sheets macros are currently being rolled out, and should be available to all users within the next few weeks.)

I doubt very much if Google "macros" will be anything like  Excel VBA
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Steve HarrisAuthor Commented:
Actually, I couldn't get the Excel Macros working, when I embedded the Excel using OneDrive live.
I'd prefer to do it in google sheets; but, at this point, on a Friday OneDrive would be fine.
0
Roy CoxGroup Finance ManagerCommented:
No macros will work online. They have to be opened from the desktop folder using either Google Drive with an Excel workbook or the OneDrive Folder on the desktop. Either way allows workbooks to be shared, OneDrive is better for colloborating.
0
Steve HarrisAuthor Commented:
Oh, so, how would I get someone to use the calculator... online?
 Basically enter 1 or 2 values and see the results?
Thanks on a Friday afternoon
0
Roy CoxGroup Finance ManagerCommented:
I'm afraid that you can't. Online calculators cannot be created using VBA in Excel or as far as I know with Google Sheets.
0
Steve HarrisAuthor Commented:
Hmmmm
I'll check out php if I one else offers a suggestion here
0
Roy CoxGroup Finance ManagerCommented:
PHP or similar is the only way, VBA will not work as a cloud based solution.
0
Steve HarrisAuthor Commented:
Thanks once more.
Would you know if there's a GoalSeek in .php
0
Roy CoxGroup Finance ManagerCommented:
sorry, I've no experience with PHP, but a google search seems to indicate that there isn't.

I know that there is a way of using Excel with JavaScript and found this

"Goal Seek" from Excel in Javascript

and also this

Goal seek into .net web calculator
0
Roy CoxGroup Finance ManagerCommented:
Any further with this?
0

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
Roy CoxGroup Finance ManagerCommented:
Pleased to help. Let us  know how you get on.
0
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.