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
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
