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.