98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - delete rows
Excel - delete rows
Resolved · Urgent Priority · Version 2007
Fri 15 May 2009, 13:26Delegate James said...
James has attended:
Access Intermediate course
Excel - delete rows
Afternoon,
I am currently recording a macro and would like to know how I can delete a row if it contains a certain text in one column and a certain text in another column. Is this possible?
The example text is "03.Adbank" in column k and "Italy" in column n, yet the countries in column n do vary. For some countries i need to delete the row and for others I leave it
Thanks
James
Fri 15 May 2009, 13:43Trainer Amanda said...
RE: Excel - delete rows
Hello James
Thank you for your question.
Automating this would require writing VBA code, which would require a trainer to investigate what exactly you would like to have done and then produce the code.
This goes beyond the extent of support that it is practicably possible for us to offer via the forum.
It is possible that you can resolve this taking a more manual approach - are you familiar with using filters in Excel?
Kind regards
Amanda
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. |
Excel tip:Adding up rows or columns without seeing formulasHighlight a column or row and click the Autosum button. This gives you your answer without showing the formula. |
