How do I change content of a cell based on date

B

Bob Phillips

Do you mean delete cells with this future date, or deletes certain cells if
an associated cell has the date.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
T

Tom Ogilvy

Onepossibility:

Look at Data=>filter=>Autofilter

filter on the date

Select the data (not the headers) and do Edit=>Delete

Only the visible rows should be deleted.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation of scanned file storage based on content 0
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
How do I change contents of a cell based on drop down list selecte 2
Visio: copy text of a master shape to User-define Cells (Variable) 0
AppleScript - How do I select a text ? 1
Changing contents of cell based on Cell Format 3
Excel does not accept text format! 0
code to unhide tabs based on cell contents 7

Top