Macros & Filters

  • Thread starter Thread starter pcor
  • Start date Start date
P

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
 
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
Click to expand...
 
Back
Top