Deleting rows with no data (in a range)
Closed
Debs269
Posts
21
Registration date
Monday October 15, 2012
Status
Member
Last seen
August 18, 2016
-
Jun 17, 2014 at 04:14 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 17, 2014 at 06:26 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 17, 2014 at 06:26 PM
Related:
- Deleting rows with no data (in a range)
- Tmobile data check - Guide
- Data transmission cable - Guide
- Download facebook data - Guide
- How to delete a row in a table in word - Guide
- Display two columns in data validation list but return only one - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 17, 2014 at 08:28 AM
Jun 17, 2014 at 08:28 AM
one approach would be to filter the rows using blank as option and delete
In case a row is populated randomly in different cells, you can use COUNTA formula in a cell of a row that is always empty and filter on 0 to filter out rows that have no data in any cell
In case a row is populated randomly in different cells, you can use COUNTA formula in a cell of a row that is always empty and filter on 0 to filter out rows that have no data in any cell
Debs269
Posts
21
Registration date
Monday October 15, 2012
Status
Member
Last seen
August 18, 2016
2
Jun 17, 2014 at 10:35 AM
Jun 17, 2014 at 10:35 AM
sorry should have written that I need VBA for this to run when input has been completed.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 17, 2014 at 06:26 PM
Jun 17, 2014 at 06:26 PM
Idea still holds true. If you start macro recorder, perform the action listed and then stop macro, you would have the macro that you seek
