i want to add the Date filter option. but i don't know to add in this code. please help me how to resolve this issue.
i want to add the Date filter option. but i don't know to add in this code. please help me how to resolve this issue.
Please help me.
Hi Sanjibghosh,
I'd be learning how to do an Advanced Filter with dates. I'd also remove all those merged cells on all your sheets as they mess things up.
https://www.ablebits.com/office-addi...vanced-filter/
After you can structure your data (without merged cells) and can do this by hand a few time, you should record a macro to show your steps. Then modify the macro to use your input boxes.
Learn to use Advanced Filters first.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi Marvin,
Thank you. But can't change the data structure. I have one search option (by BD name) in this code. but want to search the data by BD name as well as Date also. please help to resolve the issue
You might not need to change the structure. You will need to create Advanced Filters like Excel wants them. Learn Advanced Filters and it will lead to your answer. If you mean that merged cells are changing the structure, that may be a problem.
Read this also:
http://www.techrepublic.com/blog/10-...u-in-the-butt/
it is very helpful to me, if you can do it on my file.
Hi Sanjibghosh,
You need to remove those Merged Cells at the top of your sheets. If you don't remove them, you can't do this problem, as Excel works with TABLES of data. A table has header rows where each cell is a different name from the others. Because you have MERGED cells in rows 1 and 2 your data is NOT a table and you can't do Advanced Filters on it. When you said:That made your problem impossible to do for me.But can't change the data structure.
Read about TABLES of data and change your header rows for all sheets and attach your data again.
Read: http://contextures.com/xlExcelTable01.html
In the above link you don't have a "UNIQUE HEADING" because you have merged cells in rows 1 and 2.
Hi MarvinP,
Can you do it for me with out Merged Cells in my file? It is very helpful to me if you do.
This will get the data from whatever sheet you have selected from the combobox and use the dates entered in the textboxes. You will have to edit the code to get the correct column results you are looking for.
Please Login or Register to view this content.
The date fields are inaccessible - how will you enter the dates?
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi davesexcel
I am trying this code. but i am getting an error. Can you do it in my excel file and sand back? It will very helpful to me if you do it.
Your getting an error, because the name you selected does not have a sheet named after it.
Populate the comboboxes with actual sheet names, for now you can just loop through the sheets until it finds the correct sheet name, if it doesn't find it, nothing will happen.
You are asking for errors by not having the combobox populated correctly, and by using textboxes as the input dates, you could use comboboxes for that as well so there will be no chance of dates being entered incorrectly.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks