Lotus 123 Sorting macro???? 1

[Icewizz]

Hi,

I need help building an automatic report. I never used Lotus 123 macros before. I've managed to build everything else but right now I don't have the information into the proper order. I've prepared the range selection under one label but I'm not quite sure how the syntax works for this command in particular, here is what I have on the sorting;

{RANGE-NAME-CREATE "Table"}
{SELECT Table}
{SORT-RESET}
{SORT-KEY-DEFINE 1;A:a9;"Ascend"}
...

But it doesn't work right now.

Here is the structure of my data file;
PBNumber,description;FunctionCode;Description;Allocation and Amount.

(ie:181765;Consultants;Ets-12;The meening of ETS-12;0.20;2300.00)

I want it to be sorted by PBNumber and only showing it for the first time that this particular number come up with the description and on the line below, showing all of the functions and description of each with the allocation and the amount.

Example:

181765 = Consultants
Ets-12 The meening of ETS-12 20% $2300.00
Ets-15 The meening of ETS-15 30% $3400.00

181769 = Operating system
Ets-1 The meening of ETS-1 5% $1000.00

etc..

if theres any information that you may need for helping me just let me know.

Thanks,

Icewizz

 

[Icewizz]

Good news, I played with it all day yesterday and found the syntax that I needed so thanks for letting me put my help demand up.

Icewizz

 

[garrym01]

If you need to do something like this again, cheat and use the TOOLS MACRO RECORD feature. Lotus will write the script as you run through the menu commands. Just remember to turn off the recording when you are through TOOLS MACRO STOP RECORDING. You can then cut and paste from the macro transcipt box, add and change labels etc.

 

[Icewizz]

Thanks garrym01, your help as been really helpfull!!!

Icewizz