Papadopoulos
12-13-2010, 12:09 PM
I have an application that collects data simply appending the new data at the end...
I need to take this data, allow the user to select a month and a year, and have my macro copy all the relevant data to a new sheet.
Attached is sample of the data and the start of my user form.
the date that I am looking at is always in column D. The format is text and the date is formatted as m/d/y. I just want to compare what the user has entered to the m and y portions. Regular expressions? is this easier if the Date column is formatted as "date" instead of "text"?
Thanks in advance for any guidance.
David
I need to take this data, allow the user to select a month and a year, and have my macro copy all the relevant data to a new sheet.
Attached is sample of the data and the start of my user form.
the date that I am looking at is always in column D. The format is text and the date is formatted as m/d/y. I just want to compare what the user has entered to the m and y portions. Regular expressions? is this easier if the Date column is formatted as "date" instead of "text"?
Thanks in advance for any guidance.
David