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?
 
Roy CoxGroup Finance ManagerCommented:
Any further with this?
0
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
 
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:
Pleased to help. Let us  know how you get on.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.