Juriemagic
07-24-2015, 05:24 AM
Hi good people!,
I have posted on MrExcel, this is the link: http://www.mrexcel.com/forum/excel-questions/870579-visual-basic-applications-extract-data-between-two-dates.html
I have not had a good response in 3 hours, so I'm trying here. Below a copy of the thread...
I have data which populates over time Range A25:G1000000. (Using next available row method). One of the columns (column D) contains dates. I1 and J1 has each a date picker. I would like please, once I have selected the date range, and I click a form control button, (this button runs a macro that changes cell A1 from a "0" to a "1", so, in affect then, when A1 becomes "1", I would like the data extracted from columns A To G of which the dates in column D falls between the selected dates BUT ALSO including the "selected from" and "selected to" date. This info must be displayed in a userform which appears on the sheet. Once the userform is closed, I would like A1 change back to a "0", and the extracted data be cleared.
I am sure this one is going to be tough maybe, but please, I beg for this as this functionality will be the last to implement in my already complicated but very nice workbook. All and any help will be accepted with the utmost of humility and respect. Thank you all kindly..
I have posted on MrExcel, this is the link: http://www.mrexcel.com/forum/excel-questions/870579-visual-basic-applications-extract-data-between-two-dates.html
I have not had a good response in 3 hours, so I'm trying here. Below a copy of the thread...
I have data which populates over time Range A25:G1000000. (Using next available row method). One of the columns (column D) contains dates. I1 and J1 has each a date picker. I would like please, once I have selected the date range, and I click a form control button, (this button runs a macro that changes cell A1 from a "0" to a "1", so, in affect then, when A1 becomes "1", I would like the data extracted from columns A To G of which the dates in column D falls between the selected dates BUT ALSO including the "selected from" and "selected to" date. This info must be displayed in a userform which appears on the sheet. Once the userform is closed, I would like A1 change back to a "0", and the extracted data be cleared.
I am sure this one is going to be tough maybe, but please, I beg for this as this functionality will be the last to implement in my already complicated but very nice workbook. All and any help will be accepted with the utmost of humility and respect. Thank you all kindly..