Create report with Date criteria.

[ebin charles]

Hai all,

It is to create report from excel sheet data.
I have data stored in excel sheet on date wise. And in userform
I set from date & to date to create report. In sheet yellow marked column is date.

Can create report on base of date criteria set? Can I filter data within date range?

Advance thanks in this regard.

Charles

[p24leclerc]

See attached file. I modified your code to use the date textbox in the filter. Look at the code.

[jaslake]

Hi Charles

Don't know if this is what you're looking for...try it... or lose it. Select a "From Date" from the ComboBox and a "To Date" from the ComboBox then select "Create Report"..