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

 

[Akuini]

Could you upload a sample workbook to a free site such as dropbox.com or google drive & then put the link here?
It will make it easier to test and find a solution.

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

Insert another listbox and then populate the header into it.
You may need to set enable property to false & also adjust some other properties.
Like this:

 

[hsolanki]

Hi Akuini thank you for your respond. please see below link for the sample book. i have 2 users form in the book. Userform2 it is to update all the data in to each selected sheets. Userform1 is currently on working on sheet called "VehicleRejected" therefore can this be possible to work same for all worksheets from the sheet called "Master"

Sample workbook v2

MasterSheet Daily Operational Logs Click on Green Button to Update the Logs

docs.google.com

 

[Akuini]

I downloaded your workbook, but there are no userform or code, it's an .xlsx file.

 

[hsolanki]

Hi Akuini so sorry, please see below new link

Sample workbook v4.xlsm

drive.google.com

 

[Akuini]

It's been deleted.

The file you requested has been deleted​

 

[hsolanki]

Hi Sorry i had to change it

Sample workbook v4.xlsm

drive.google.com

 

[Akuini]

can this be possible to work same for all worksheets from the sheet called "Master"

I don't understand what you mean. Can you explain in more detail?

 

[hsolanki]

you can now download the above file which has all the code. sample workbook v4 above.

no because link was not working therefore i had to re post the link to download.

 

[Akuini]

I've downloaded the sample workbook v4 & I need you to explain in more detail about what you need because I don't understand it.