Deleting empty rows in excel
Closed
Aks
-
Jun 18, 2010 at 01:15 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 18, 2010 at 02:38 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 18, 2010 at 02:38 PM
Hello,
I have a worksheet which will have certain status like incomplete, rejected or approved in the Column C. If the status is rejected or incomplete, the next one or two rows will have some comments which needs to be copied and pasted into the H or G column alongside with the status. After ther comments there is a blank row which needs to be deleted. How to go about it?
I have a worksheet which will have certain status like incomplete, rejected or approved in the Column C. If the status is rejected or incomplete, the next one or two rows will have some comments which needs to be copied and pasted into the H or G column alongside with the status. After ther comments there is a blank row which needs to be deleted. How to go about it?
Related:
- Deleting empty rows in excel
- Number to words in excel - Guide
- Gif in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Marksheet in excel - Guide
- How to take screenshot in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 18, 2010 at 02:38 PM
Jun 18, 2010 at 02:38 PM
You can do it by macro.
I have a feeling that you already knew that much and are looking for macro. If that is the case indeed, then Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
I have a feeling that you already knew that much and are looking for macro. If that is the case indeed, then Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too