Need to convert an old Lotus 123 "Macro to Excel 2010 - Help!

[HahnsPCs]

I have a Lotus 123 file with 3 sheets ("A", "Results", & "Graphing"). It has a Macro that copies the last row of column "A" on Sheet "A" to the next clean row on sheet "A", and makes some changes to the fields in that new copied row based upon some work in other fields... The first part of this single Macro merely copies the last row of column "A" on Sheet "A" to the next clean row on sheet "A" \a {goto}a:a1~ {end}{d}{end}{d} /c{r 180}~{d}~ {d} It's this NEXT part that's killing me to convert from Lotus 123 to Excel (and yes, it's a GREAT new Century from LOTUS! Ugh!)... The Actual Lotus Macro continues as: /cnewdate~~{r 2}/cnewnav~~ {goto}trc~ /cnewtotret~mstar~ /cnewnav~price2~ /readjyield~ /rvyield1~adjyield~{calc} /rvyield2~adjyield~{calc} /rvyield2~adjyield~{calc} /rvyield2~adjyield~{calc} {goto}macro~ The FIRST Line of this second part of the MACRO (/cnewdate~~{r 2}/cnewnav~~) takes the Value from "Results:BA3" (Named "Newdate") and copies it to the First Column "A:A(newly created row)" of the new row created in the first part of the MACRO, and then shifts over two columns ({r 2}), and takes the value from "Results:BB3" (named "newnav") and copies it there to "A:C(newly created row)"... The SECOND Line of this second part of the MACRO ({goto}trc~) Simply goes to A:DU7 through A:DX22 but it doesn't appear to DO anything... The THIRD Line of this second part of the MACRO (/cnewtotret~mstar~) copies the value of "Results:BC3" (/cnewtotret~) to "A:DV22" (mstar~) The FOURTH Line of this second part of the MACRO (/cnewnav~price2~) copies the value of "Results:BB3" (/cnewnav~) to "A:DW25" (price2~) The FIFTH Line of this second part of the MACRO (/readjyield~) simply deletes the value from "A:DX22" (/readjyield~) The SIXTH Line of this second part of the MACRO (/rvyield1~adjyield~{calc}) Seems to make some calculation from "A:DW29" (/rvyield1~) and "paste special" using "Formulas as values" to "A:DX22" (adjyield~{calc}) The SEVENTH, EIGHTH, and TENTH Lines all seem to repeat to get an accurate result... I guess it was found that if the calculation was run once or twice it wasn't always accurate, where third times the charm... It some a similar bit of work like the SIXTH Line, just drawing from a different field... All 3 steps run /rvyield2~adjyield~{calc} to make some calculation from "A:DX29" (/rvyield2~) and "paste special" using "Formulas as values" to "A:DX22" (adjyield~{calc}) The TWELTH and FINAL Line of this second part of the MACRO ({goto}macro~) just seems to return to the location the Macro is written on "Results:BA1" Any help SO appreciated!!! Thanks!

 

[jsotola]

could you please restate your request in a readable format

please post in code tags so that any spacing that you put in does not get deleted

i do not think that anyone is going to bother untangling the "blob" of words that you have presented in your post

 

[HahnsPCs]

Apologies for the formatting mess... new to the forums... Can't quite figure out WHY carriage returns/line breaks are not adhered to outside of "code" boxing or using "advanced posting"...

Anyhow...

I have a Lotus 123 file with 3 sheets ("A", "Results", & "Graphing").

It has a Macro that copies the last row of column "A" on Sheet "A" to the next clean row on sheet "A", and makes some changes to the fields in that new copied row based upon some work in other fields...

The first part of this single Macro merely copies the last row of column "A" on Sheet "A" to the next clean row on sheet "A"

\a {goto}a:a1~
{end}{d}{end}{d}
/c{r 180}~{d}~
{d}

It's this NEXT part that's killing me to convert from Lotus 123 to Excel (and yes, it's a GREAT new Century from LOTUS! Ugh!)...

The Actual Lotus Macro continues as:

/cnewdate~~{r 2}/cnewnav~~
{goto}trc~
/cnewtotret~mstar~
/cnewnav~price2~
/readjyield~
/rvyield1~adjyield~{calc}
/rvyield2~adjyield~{calc}
/rvyield2~adjyield~{calc}
/rvyield2~adjyield~{calc}
{goto}macro~

The FIRST Line of this second part of the MACRO (/cnewdate~~{r 2}/cnewnav~~) takes the Value from "Results:BA3" (Named "Newdate") and copies it to the First Column "A:A(newly created row)" of the new row created in the first part of the MACRO, and then shifts over two columns ({r 2}), and takes the value from "Results:BB3" (named "newnav") and copies it there to "A:C(newly created row)"...

The SECOND Line of this second part of the MACRO ({goto}trc~) Simply goes to A:DU7 through A:DX22 but it doesn't appear to DO anything...

The THIRD Line of this second part of the MACRO (/cnewtotret~mstar~) copies the value of "Results:BC3" (/cnewtotret~) to "A:DV22" (mstar~)

The FOURTH Line of this second part of the MACRO (/cnewnav~price2~) copies the value of "Results:BB3" (/cnewnav~) to "A:DW25" (price2~)

The FIFTH Line of this second part of the MACRO (/readjyield~) simply deletes the value from "A:DX22" (/readjyield~)

The SIXTH Line of this second part of the MACRO (/rvyield1~adjyield~{calc}) Seems to make some calculation from "A:DW29" (/rvyield1~) and "paste special" using "Formulas as values" to "A:DX22" (adjyield~{calc})

The SEVENTH, EIGHTH, and TENTH Lines all seem to repeat to get an accurate result... I guess it was found that if the calculation was run once or twice it wasn't always accurate, where third times the charm... It some a similar bit of work like the SIXTH Line, just drawing from a different field... All 3 steps run /rvyield2~adjyield~{calc} to make some calculation from "A:DX29" (/rvyield2~) and "paste special" using "Formulas as values" to "A:DX22" (adjyield~{calc})

The TWELTH and FINAL Line of this second part of the MACRO ({goto}macro~) just seems to return to the location the Macro is written on "Results:BA1"

Again, any assistance GREATLY Appreciated!!!