Dear Sir,
Thanks a lot for your valuable reply.
but i am still facing problem.
- 1st of all i want to store the date in DD-MM-YYYY format in may data base. kindly refer the sheet name "MDB".
- Then i want to use the advance filter method to short out the data based on the multiple criteria range as mentioned on sheet name as "Filter_Data"
- I made the change in micro as per your valuable guidance but code is not giving error.
- i want the data criteria to be entered in DD-MM-YYYY format.
- As per Advance filter micro, i have to mentioned the data criteria, i.e start date as "greater or equal to date value" and end data as "less than or equal to date value".
- get_nit_date() micro was writeen to just capture the greater than or equal to sign or less than or equal to signed. in fact that code is not required. i had to simply write the date value with >= or <= in cell no. B5 and C5 of sheet name as "filter_Data". but when i put the date manually then also advance filter result not work so i though that i should write a code for capturing these >= or <= operator along with date.
It would be great help, if you please spare your valuable time and have a look in my data base sheet, whether i am doing mistake in date format there or or i am doing mistake in criteria sheet.
I shall be highly obliged if you please short out what i am doing wrong. i am very beginner in VBA coding.
updated excel file is enclosed for reference.
Store photos and docs online. Access them from any PC, Mac or phone. Create and work together on Word, Excel or PowerPoint documents.
1drv.ms
With Regards
Prabhakar