I have a sheet with about 5000 rows in column. I would like to know how to add a blank row at every change in column "B"
TIA. John.
I have a sheet with about 5000 rows in column. I would like to know how to add a blank row at every change in column "B"
TIA. John.
Hello John,
Here is a macro that will sort the data in column "B" and then insert blank cells where the data changes. You can change the starting row and column (marked in blue). It is set to "B1". The macro finds the last row automatically. To run the macro, you can attach it to a command button (Forms Toolbar), or type ALT+F8 to run it from the macro dialog.
Adding the Macro![]()
Please Login or Register to view this content.
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Right Click on any Sheet's tab
4. Left Click on View Code in the pop up menu
5. Press the keys ALT+I to activate the Insert menu
6. Press M to insert a Standard Module
7. Paste the code by pressing the keys CTRL+V
8. Make any custom changes you need to the macro
9. Save the Macro by pressing the keys CTRL+S
Sincerely,
Leith Ross
Cheers Leith, this is excellent.
Great Scottish name BTW.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks