verticalreflect
New Member
- Joined
- Sep 12, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello. I’m hoping you can help.
I have limited Excel skills and I’m a total beginner when it comes to building Macros.
I’ve been given a task to complete, described as below:
I have a sheet (second tab in workbook) which comprises of 7 columns.
I’m looking to build a Macro which will run through each of these rows, identifies any rows which have incomplete data (one or more cells within a row are empty), deletes them from this sheet but pastes the entire row into tab four of the workbook (which is formatted in exactly the same way, 7 columns with the same headings.
Apologies if this is poorly explained, but happy to provide any more info required!
Thanks
I have limited Excel skills and I’m a total beginner when it comes to building Macros.
I’ve been given a task to complete, described as below:
I have a sheet (second tab in workbook) which comprises of 7 columns.
I’m looking to build a Macro which will run through each of these rows, identifies any rows which have incomplete data (one or more cells within a row are empty), deletes them from this sheet but pastes the entire row into tab four of the workbook (which is formatted in exactly the same way, 7 columns with the same headings.
Apologies if this is poorly explained, but happy to provide any more info required!
Thanks