Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
insert row at each change of surname in excel
I have a list of 650 entries using 40 surnames - sometimes only appearing
once, others 7 times. At every change in surname, I would need to insert a row. Thanks -- De |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
insert row at each change of surname in excel
something like this sub insertrows() for i=cells(rows.count,"a").end(xlup).row to 2 step -1 if cells(i-1,"a")<cells(i,"a") then rows(i).insert next i end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "De" wrote in message ... I have a list of 650 entries using 40 surnames - sometimes only appearing once, others 7 times. At every change in surname, I would need to insert a row. Thanks -- De |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
insert row at each change of surname in excel
Why do you want to do this? It will mess things up for sorting if you should
ever want to do that. Maybe just consider making the rowheight larger, if it's just for display purposes......that will still sort, and is easily correctable. Vaya con Dios, Chuck, CABGx3 "De" wrote: I have a list of 650 entries using 40 surnames - sometimes only appearing once, others 7 times. At every change in surname, I would need to insert a row. Thanks -- De |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
insert row at each change of surname in excel
The formula has really helped. Many thanks,
De "De" wrote: I have a list of 650 entries using 40 surnames - sometimes only appearing once, others 7 times. At every change in surname, I would need to insert a row. Thanks -- De |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change around surname and name | Excel Discussion (Misc queries) | |||
excel to recog a surname, + paste address associated in new cell | Excel Discussion (Misc queries) | |||
Can you change something in Excel to automatically insert an equa. | Excel Discussion (Misc queries) | |||
change the default word in the insert comment option in excel | Setting up and Configuration of Excel | |||
change the default word in the insert comment option in excel | Setting up and Configuration of Excel |