$$Excel-Macros$$ Date filter Help

2016-03-04 Thread rekha siri
Hi Experts, can some one please advise me the process or code to delete the records from sheet 2 and specified dates in sheet 1 criteria . i am attaching sample data please advise me how to use vba macros in this regards. Thanks for your help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

Re: $$Excel-Macros$$ Date filter Help

2016-03-08 Thread Paul Schreiner
Here's a macro to delete records by date. The Technique:Since I didn't know how many records you have or dates to process,I elected to store the dates in a Dictionary Object.This makes it VERY fast to verify if the dates in the records are included in the Deletion list. I then processed the recor