Link to home
Start Free TrialLog in
Avatar of Steve Harris
Steve Harris

asked on

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
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image
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
Avatar of Steve Harris
Steve Harris

ASKER

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.)
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image
(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
Avatar of Steve Harris
Steve Harris

ASKER

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.
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image
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.
Avatar of Steve Harris
Steve Harris

ASKER

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
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image
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.
Avatar of Steve Harris
Steve Harris

ASKER

Hmmmm
I'll check out php if I one else offers a suggestion here
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image
PHP or similar is the only way, VBA will not work as a cloud based solution.
Avatar of Steve Harris
Steve Harris

ASKER

Thanks once more.
Would you know if there's a GoalSeek in .php
SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image
Pleased to help. Let us  know how you get on.