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" wrote in message
...
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.