Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

writing formula delete specific

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Writing formula to delete specific lines

Writing formula to delete specific lines

ResolvedVersion 2003

Linda has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Writing formula to delete specific lines

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?

RE: writing formula to delete specific lines

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

Excel tip:

Quickly Adding New Worksheets

Want to place a new Excel worksheet before current worksheet. Use keystroke SHIFT+F11

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.