Listbox to show multi sheets data using between 2 dates

[hsolanki]

Hi i have userform whereby when you select 2 different dates and name find, shows all the data for the matched person i was wondering if there is any easy way to show all multi sheets for same name between the 2 dates ranges shows all the matched person data into list box

currently userform only works in the active sheet with the command button, but i want to be able to show all multi sheets from the main master sheet.

also how can i add an header for the each columns in list box

 

[hsolanki]

I need to do 2 things.

First- listbox1 in Userform1 to be able to show with sheet header.

Second - I want Userform1 to extract datas from all multi sheets at one time when it is found match from all sheets using between 2 dates and Name search. Date and time it's in column A in all sheets and Name it is in column H

I hope this has helped you to understand of what I need to do with the Userform1.

 

[Akuini]

The table in all sheet have different header, so do you want to include all header in the listbox?

 

[hsolanki]

Can this be possible by having multitabs in Userform1? Same like Userform2 I have done.

 

[hsolanki]

or perhaps having different listboxes of each sheets and only shows if data have been found from the search criteria?

 

[Akuini]

Hi, hsolanki, sorry for the late replay.
I've read your file.
You already have a long code in your userform. Actually, it's rather hard for me to understand someone's else code, it's too much work. And also I'm not familiar with using multipage userform.
So I hope somebody else here could help you with that.

So I just want to show you how to use a second listbox to populate the header.
Here's an example:

example - listbox header using another listbox.xlsm

Shared with Dropbox

www.dropbox.com

 

[hsolanki]

Morning Akuini No problem, many thanks for at least training. and also i will try to work around with the header and 2 listboxes.

Thank you once again.