I need to copy titles that are not repeating on each row to each individual
rows accross the whole range
Example
a 1
2
3
4
5
b 12
13
14
c 15
16
18
20
21
and so on

I need to copy the letter "a" down up to 5 and "b" up to 14 and "c" up to
21 in one process.

Thanks

Position your cursor in the first blank cell below the first "a" (i.e.
next to 2 in your example). Then press F5 (GoTo) and click Special
then click Current Region. Then press F5 again, click Special, then
click Blanks. Then type = and click on the cell above where the cursor
is and press Ctrl-Enter - all your blanks will be filled how you want
them. You can fix the values by using Edit | Paste Special.

Hope this helps.

Pete

On Sep 11, 12:52 am, toolate88 <toolat...@discussions.microsoft.com>
wrote:
> I need to copy titles that are not repeating on each row to each individual
> rows accross the whole range
> Example
> a 1
> 2
> 3
> 4
> 5
> b 12
> 13
> 14
> c 15
> 16
> 18
> 20
> 21
> and so on
>
> I need to copy the letter "a" down up to 5 and "b" up to 14 and "c" up to
> 21 in one process.
>
> Thanks

John Walkenbach shows how to do it here... http://j-walk.com/ss/excel/usertips/tip040.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"toolate88"
wrote in message
I need to copy titles that are not repeating on each row to each individual
rows accross the whole range
Example
a 1
2
3
4
5
b 12
13
14
c 15
16
18
20
21
and so on

I need to copy the letter "a" down up to 5 and "b" up to 14 and "c" up to
21 in one process.
Thanks