Lotus macro that I need for an Excel file

[Jeff Stanley]

Here is the macro that we ran in Lotus:

{IF SPEC="CH"}/RVSPECCH~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="AG"}/RVSPECAG~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="RR"}/RVSPECRR~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="BE"}/RVSPECBE~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="AB"}/RVSPECAB~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="MAGNELOO"}/RVSPECMAGNELOO~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="RV"}/RVSPECRV~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="KALAOO"}/RVSPECKALAOO~DIMENSIONS~{CALC}:PRSPRESSCHART~G
{IF SPEC="KALAGR"}/RVSPECKALAGR~DIMENSIONS~{CALC}:PRSPRESSCHART~G

If the range named SPEC="CH" - / range SPECCH was copied to the range named DIMENSIONS - and the range name PRESSCHART was printed. It kept running until it found a match. We need to have the macro look for a match from a long list of choices - we have many specs. Hope this is enough information? Thanks for your help!

 

[Smitty]

I haven't used Lotus in a long time, but per Mark O'
Brien in this post:http://www.mrexcel.com/board2/viewtopic.php?t=68814
They'll have to be recoded manually. Although it seems like you maybe able to copy and paste quite a bit as opposed to retyping everything.

Hope that helps,

Smitty