Inputting Data

- I have to enter tens of thousands of number ranges

- There are various columns and each number range includes 10 numbers (00-09, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99).

- There is only one column that needs to be changed for each number range. I have the various values that need to be changed in another spreadsheet.

- The problem is that I would have to copy it 10 times for each range (Ex1 00-09, Ex1 10-19, Ex1 20-29, Ex1 30-39, Ex1 40-49, Ex1 50-59, Ex1 60-69, Ex1 70-79, Ex1 80-89, Ex1 90-99).


Example:

A1 B1 C1
Ex1 00 09
Ex1 10 19
Ex1 20 29
Ex1 30 39
Ex1 40 49
Ex1 50 59
Ex1 60 69
Ex1 70 79
EX1 80 89
EX1 90 99

Ex2 00 09
Ex2 10 19
Ex2 20 29
Ex2 30 39
Ex2 40 49
Ex2 50 59
Ex2 60 69
Ex2 70 79
EX2 80 89
EX2 90 99

Ex3 00 09
Ex3 10 19
Ex3 20 29
Ex3 30 39
Ex3 40 49
Ex3 50 59
Ex3 60 69
Ex3 70 79
EX3 80 89
EX3 90 99

And so on and so forth...


How to I take a single value and duplicate it 10 times into Column A, while leaving the rest of the data (number ranges) static?

Thanks in advance.

To do 10 at a time, I'd Search and Replace Ex1 with Ex2. If you select a range and do Search and Replace it will only do it in the selected range.

You're thinking this is great for 10 but how about 10,000.? I'd write some VBA code that did a for next loop selecting 10 rows at a time and searching and replacing the Ex#.

To give you a better answer or a slicker way we need a sample spreadsheet. You and attach a sample by clicking on "Go Advanced" and then on the paperclip icon.

Hey Martin,
Great answer. You taught me something new. Thanks!

Now lets see if 2nice reads how to do it and saves a huge amount of time with your method.

I've attached an example. Thanks for your replies