Posted to microsoft.public.excel.programming

Joe K.

external usenet poster

Posts: 41

Delete/Add Dates To Worksheet

I have a worksheet (Sheet1) that has date field in Column A. The worksheet
should have 6 months of data in it. Please help me create a macro than will
delete
dates older than the current date and delete the entire row and shift the
rows up that were not deleted. Next make sure there are 6 months of dates in
Column A in the Sheet1. If are not add the missing dates to the worksheet.

Thanks,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to delete Excel worksheet using VBA without delete dialog?	cocalico22	Excel Programming	4	September 15th 06 10:34 PM
delete rows with dates between	dan	Excel Programming	2	June 30th 06 09:34 PM
Delete rows between two dates	jocker	Excel Programming	12	December 2nd 05 06:02 PM
Delete Rows whose value is not between 2 dates	Dominique Feteau[_2_]	Excel Programming	4	March 3rd 05 01:59 PM
Delete Rows with particular dates	Al Mackay	Excel Programming	3	November 2nd 04 09:14 AM

All times are GMT +1. The time now is 06:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us