Marcos

cj,

Do you have a system for determining the last two numbers? Writing the macro to do it automatically
(or even using a formula) would be a lot easier than using manual input.

HTH,
Bernie
MS Excel MVP


"cjloneranger" <[email protected]> wrote in message
news:[email protected]...
>I need to input the following data: 1:18, 1:32, 1:64 (and others) in random
> order on a hugh spread sheet (Column down). I was hoping to put 1:18 in all
> the rows then use a macro to pull up the data, back space twice, allow me to
> input the last two numbers needed and then when I hit enter go down to the
> next row. I know it was possible with Lotus put can't seem to find how to do
> it in Excel. Can anyone help? I'm using Excel 2002.

cj,

Do you have a system for determining the last two numbers? Writing the macro to do it automatically
(or even using a formula) would be a lot easier than using manual input.

HTH,
Bernie
MS Excel MVP


"cjloneranger" <[email protected]> wrote in message
news:[email protected]...
>I need to input the following data: 1:18, 1:32, 1:64 (and others) in random
> order on a hugh spread sheet (Column down). I was hoping to put 1:18 in all
> the rows then use a macro to pull up the data, back space twice, allow me to
> input the last two numbers needed and then when I hit enter go down to the
> next row. I know it was possible with Lotus put can't seem to find how to do
> it in Excel. Can anyone help? I'm using Excel 2002.

I need to input the following data: 1:18, 1:32, 1:64 (and others) in random
order on a hugh spread sheet (Column down). I was hoping to put 1:18 in all
the rows then use a macro to pull up the data, back space twice, allow me to
input the last two numbers needed and then when I hit enter go down to the
next row. I know it was possible with Lotus put can't seem to find how to do
it in Excel. Can anyone help? I'm using Excel 2002.

cj,

Do you have a system for determining the last two numbers? Writing the macro to do it automatically
(or even using a formula) would be a lot easier than using manual input.

HTH,
Bernie
MS Excel MVP


"cjloneranger" <[email protected]> wrote in message
news:[email protected]...
>I need to input the following data: 1:18, 1:32, 1:64 (and others) in random
> order on a hugh spread sheet (Column down). I was hoping to put 1:18 in all
> the rows then use a macro to pull up the data, back space twice, allow me to
> input the last two numbers needed and then when I hit enter go down to the
> next row. I know it was possible with Lotus put can't seem to find how to do
> it in Excel. Can anyone help? I'm using Excel 2002.