I need to search multiple sheets for a word, how? fairly new to excel.

[NDMA]

I own a music school and have created the daily run sheets in excel and successfully used vlookup's to get pay codes working, I now want to be able to find all my available times/days and have them appear on one sheet for enquiry purposes.

Its been a while since I did the initial set up of the sheets and am a bit rusty on the coding, If anyone can help that would be great!

[Naveed Raza]

i have a code but i need sample workbook to test on it and onemore thing u want a inputbox for search value or its default number

[NDMA]

Thanks for the reply,
Not sure how to send you a sample workbook, and not sure about what you are looking for, like I said, pretty new to this whole thing and have never worked with macro before

[Naveed Raza]

i need word sample document

To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)

[Naveed Raza]

Hi Try this attached file

Note: Put all Excel(.xls) files in one path and mention that path in attached file in cell F6 and then click on button

hope this will work