writing formula delete specific

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

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

Writing formula to delete specific lines

resolvedResolved · Low Priority · Version 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:

Recovering Unsaved Work in Excel 2010

Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back.

Choose File then Info, click Manage Versions and then Recover Unsaved Workbooks which will automatically find the spreadsheets that haven't been saved.

View all Excel hints and tips


Server loaded in 0.08 secs.