| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert blank row when cell changes
Hi,
I have sorted a long list of data. I now have some cells that are the same and then the data changes. What I want to do is insert a blank row everytime the cel value changes. For eg... ColumA John John Tony Andrea Andrea Andrea Ivano Tom So the macro would look at column A and everytime the name changes it will insert a blank row. Thanks, Ivano |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert blank row after change in cell value not working. | Excel Discussion (Misc queries) | |||
| How to insert a slash into a blank cell | New Users to Excel | |||
| Auto insert a blank row above the current row based on a cell val. | Excel Discussion (Misc queries) | |||
| insert info only if cell is blank (Max from Singapore ref) | Excel Discussion (Misc queries) | |||
| if cell is blank insert a zero | Excel Discussion (Misc queries) | |||
Threaded Mode
