Hi.
I have exported names and addresses from another program into excel spreadsheet for a few thousand people. The data runs vertically down the sheet for each person as follows:
Cell A1 - Name
Cell A2 - Address Line 1
Cell A3 - Address Line 2
Cell A5 - Name
Cell A6 - Address Line 1
Cell A7 - Address Line 2
Lets call the three cells an 'address block'. For each name, i would like there to be six rows until the next address block starts. In some cases it is already six however sometimes its five or four. To manually format it will take me days because there are thousands.
I would like to know of a formula/macro that can either insert or delete a row accordingly to comply with the above. Something like a macro with an if statement - i'm not too sure. Any help would be greatly appreciated
Im using Excel 2007 version.
I have exported names and addresses from another program into excel spreadsheet for a few thousand people. The data runs vertically down the sheet for each person as follows:
Cell A1 - Name
Cell A2 - Address Line 1
Cell A3 - Address Line 2
Cell A5 - Name
Cell A6 - Address Line 1
Cell A7 - Address Line 2
Lets call the three cells an 'address block'. For each name, i would like there to be six rows until the next address block starts. In some cases it is already six however sometimes its five or four. To manually format it will take me days because there are thousands.
I would like to know of a formula/macro that can either insert or delete a row accordingly to comply with the above. Something like a macro with an if statement - i'm not too sure. Any help would be greatly appreciated
Im using Excel 2007 version.