gratefuljames
New Member
- Joined
- Nov 2, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Greetings,
I would like to get help to create a loop in VBA that will do the following in Excel Office 365:
- loop down entire column and find 2 consecutive empty rows in column A
- combine data from last empty row +2 rows down thru last row with data before the next 2 consecutive empty rows, including any empty row, in the same layout
- paste the combined data into column B, on the row where the 1st row with data appears for each block between consecutive empty rows
- delete empty rows in column B
Below is a sample data:
Below is what it should look like after combining the data and pasting
Below is after deletion of empty rows in column B
I appreciate any help.
Thanks,
James
I would like to get help to create a loop in VBA that will do the following in Excel Office 365:
- loop down entire column and find 2 consecutive empty rows in column A
- combine data from last empty row +2 rows down thru last row with data before the next 2 consecutive empty rows, including any empty row, in the same layout
- paste the combined data into column B, on the row where the 1st row with data appears for each block between consecutive empty rows
- delete empty rows in column B
Below is a sample data:
Below is what it should look like after combining the data and pasting
Below is after deletion of empty rows in column B
I appreciate any help.
Thanks,
James