Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Titles in a long list of rows
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Titles in a long list of rows
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 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Titles in a long list of rows
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
excel chart options titles tab should allow copy paste in fields | Charts and Charting in Excel | |||
need to copy a long list of file names | Excel Discussion (Misc queries) | |||
Need Macro for List of Book Titles | Excel Worksheet Functions | |||
Setting up a random list from long list of names ? | Excel Discussion (Misc queries) |