Writing formula to delete specific lines

Resolved · Low Priority · Version 2003

Linda has attended:
Excel Advanced course
Excel VBA course

by - delegate Linda [7 posts] (2008 Jul 1 Tue, 14:31) Reply

Hi there, I have a big table and each month I have to delete out some old lines and send it to clients. I want to know if there is a way to "say" to excel "if this cell is less than x THEN delete row." Any suggestions?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: writing formula to delete specific lines

by - delegate Linda [7 posts] (2008 Jul 1 Tue, 14:33) Reply

actually this is meant to be in excel section! I've changed it, please ignore.

· Tools From Advanced Excel Courses: Goal Seek and Solver
· Database Tips from an Excel Training Course
· Improve Performance Of Your Excel Macros
· Microsoft Excel Training: Essential for Today's Employees
· Features of Microsoft Excel that assist in Analysis of Financial Data

Please browse our web site to find out more about
intermediate microsoft word course london and other Microsoft training courses.

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips

Rate this page: