Marcos

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to find the most common pairs and triplets numbers? 5
Arrayformulas with either/or nested to sumproduct if eitherconditions are true 13
Scrabble Value calculation for Welsh words 0
Alt codes 4
USE EXCEL MARCO LIKE OLD VERSION LOTUS-123 ---> {?} 3
Conditional formatting on a dynamic range - workaround 1
Random Numbers 1
how do i drag a formula 3

Back
Top