The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - delete rows

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Excel - delete rows

Resolved · Urgent Priority · Version 2007

ReplyFri 15 May 2009, 13:26Delegate James said...

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

For upcoming training course dates see: Pricing & availability

ReplyFri 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

ReplyFri 15 May 2009, 13:45Delegate James said...

RE: Excel - delete rows

Yes I am familiar with filters, I will write some code to perform the function for me yet I thought there was a way round that

Thanks

Excel articles

· Excel: From The Basic To The Advanced
· Do You Need To Run Excel 2007 In Compatibility Mode?
· Microsoft Excel Training: Not Just for Newbies Anymore
· How Small Businesses Profit from Outside Excel Training
· The Key Settings In Excel 2003's Options Panel

Please browse our web site to find out more about
microsoft+excel+training and other Microsoft training courses.

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips

The 7 Deadly Presentation Sins

Many of us are told what we should be doing during a presentation, but do you know what might slip you up? Here are the seven deadly presentation sins that may mean the difference between applause - or stunned silence. So are you a sinner or a saint?

» Article: Presentation skills london

Would you be able to email me a list of shortcuts eg: Ctrl C = copy, Cont V = paste, f9 = update all