Converting Lotus function to Excel
 

I wish to transfer my database from Lotus 1-2-3 to Excel but I am
unable to convert the macro.

The macro I am trying to convert is:


\t {GET-NUMBER Enter day...,c2,;DAY OF MONTH,,}
{calc}~{GOTO}TITL2~{GOTO}TITL3~{GOTO}TITL~/WTB

Cell (Column A) I have my SKU's, (Column B) Description, then days of
the month begining at cell D4 across.

I want to input my stock according to day received. Lets say I receive
a shipment March 4 and I input the sku no. which would begin at G4
(March 1),G5 (March 2),G6 etc. I want it to only highlite the cell in
cell G according to the SKU. until the day of the month is changed.

Thanks,
Rube

Converting Lotus function to Excel
 

Sorry failed to include below.

On Sat, 04 Mar 2006 23:07:18 GMT, Rubix wrote:

I wish to transfer my database from Lotus 1-2-3 to Excel but I am
unable to convert the macro.

The macro I am trying to convert is:

\b {goto}{?}~
{R 5}
{?}~/xg\b~


\t {GET-NUMBER Enter day...,c2,;DAY OF MONTH,,}
{calc}~{GOTO}TITL2~{GOTO}TITL3~{GOTO}TITL~/WTB

Cell (Column A) I have my SKU's, (Column B) Description, then days of
the month begining at cell D4 across.

I want to input my stock according to day received. Lets say I receive
a shipment March 4 and I input the sku no. which would begin at G4
(March 1),G5 (March 2),G6 etc. I want it to only highlite the cell in
cell G according to the SKU. until the day of the month is changed.

What happens:

Ctrl+T pop-up appears asking for day of month. Day is entered.

Ctrl+B pop-up appears asking for sku number. SKU is entered and the
cell is highlited were day and sku meet.

Amount is entered and select Enter. Pop-up reappears and next SKU is
entered.


Thanks,
Rube