ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Date specific Macro (https://www.excelbanter.com/excel-programming/316468-date-specific-macro.html)

DB100[_19_]

Date specific Macro
 

Hi all

I have a list of data that has a date in column A.

I have a set of Macro commands that I am able to run on this data, bu
am having to Filter / Cut / Copy certain date ranges to another boo
before running them.

I would like to be able to use a userform so that the user can ente
two sets of dates and the macro will only run on the data that fall
into that range.

Is this possible, can anyone let me know what the code would be to tel
the macros that the only data that it should be looking at is in betwee
the dates.

It would even be ok for the macro to automatically copy these dat
ranges to a new book and then start the macro.

Thanks for any help

Davi

--
DB10
-----------------------------------------------------------------------
DB100's Profile: http://www.excelforum.com/member.php...nfo&userid=917
View this thread: http://www.excelforum.com/showthread.php?threadid=27739



All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com