Good Morning,
I have basic VBA Skills. My spreadsheet has a lot of rows and columns with row G with address numbers. I am using the following code to enter a blank line before each number that doesn't match the one below it For example:
234
234
235
236
236
becomes:
234
234
235
236
236
I also need to copy and paste row 1 into each of the newly created blank rows. I want to copy and paste so the format will be maintained. I have this below but I have to manually enter each row to enter it which defeats the purpose of automating.Please Login or Register to view this content.
I would like this to be combined into one single code and have it auto fill.Please Login or Register to view this content.
Thank you for your help in advance.
Bookmarks