Macros & Filters

[pcor]

Hi
I have a spreadsheet that contains many cols of which one displays dates.
I very often had to select entries by date, so I apply the filter and select
the require date, and then copy the results to another sheet to work on
I would like a macro that would automate the entire procress
Load the file, apply the filter and then copy the reults to another
worksheet.
I am stuck on how to pause the macro to input the the required date- which
varies quite a bit.
Will any one help please
Thanks

 

[Dave Peterson]

See one guess at your other post.

Hi
I have a spreadsheet that contains many cols of which one displays dates.
I very often had to select entries by date, so I apply the filter and select
the require date, and then copy the results to another sheet to work on
I would like a macro that would automate the entire procress
Load the file, apply the filter and then copy the reults to another
worksheet.
I am stuck on how to pause the macro to input the the required date- which
varies quite a bit.
Will any one help please
Thanks