Forum home » Delegate support and help forum » Microsoft Excel Training and help » Delete row if a cell in a column is blank
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Delete row if a cell in a column is blank
Resolved · High Priority · Version 2007
Reply Wed 25 Jan 2012, 10:09Delegate Tashi said...
Tashi has attended:
No courses
Delete row if a cell in a column is blank
What is the macro to delete a row if a cell in a specific column is blank? Is there a way to do this without using macros or doing it manually?
For upcoming training course dates see: Pricing & availability
RE: Delete row if a cell in a column is blank
Can you please clarify cell in a column is blank?
thanks
paul
Reply Wed 25 Jan 2012, 12:36Delegate Tashi said...
RE: Delete row if a cell in a column is blank
By blank cell, I mean a cell with nothing entered into it. It does not have a value of 0
RE: Delete row if a cell in a column is blank
how many rows are using the column? ie, are there 20 rows and if 1 cell out of 20 is blank you want to delete the entire column?
Reply Wed 25 Jan 2012, 12:51Delegate Tashi said...
RE: Delete row if a cell in a column is blank
There are 300 rows. If the cell in column C is blank ( i.e. no data entered) for that row I want to delete the entire row that includes the blank column C cell. It's a very simple table. There is a possibility that afterwards I will want to repeat the process but with a different column.
RE: Delete row if a cell in a column is blank
it really depends on how often you are going to run this delete operation. If its every now and then I would suggest you simply put a filter on the header, filter the non blanks and then delete them manually. You can create a macro for this but that gets a bit more complicated.
Does that help?
Reply Wed 25 Jan 2012, 17:26Delegate Tashi said...
RE: Delete row if a cell in a column is blank
Yes, Thanks
|