Copy Titles in a long list of rows

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

Guest

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
 
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
 
Back
Top