macro to look through all available sheets in a workbook

[Shellybelly]

I need a macro that will search all available sheets in a workbook for a name and return data for that name under specific column labels..

Results Sheet:
Name
Shel clark

Date
1/1/2014

Total Hrs
8

Break Duration
30

[Leith Ross]

Hello Shellybelly,

Will the headers always be in the same columns on each sheet?

Where will the results be output to?

[Shellybelly]

Yes the headers will always be the same in the same on each sheet.

[Leith Ross]

Hello Shellybelly,

Once the name and associated information are found, where is it to be pasted?

[Shellybelly]

It will be paste in a sheet name Reg Search. the name will be typed in column b3 in the reg search tab and all the info for that person recorded for each day will be paste under the same columns that is in all the other sheets.

[Shellybelly]

Any Luck yet Leith Ross?

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Shellybelly]

Hi JOHN H. DAVIS I tried the macro but no luck.

I've attached the sheet so you can see. I've tried a macro to put the search results in a message box but no luck. I only got the sheet name and the cell the name was found. when i try your code nothing happens. Maybe I am doing something wrong.

I've attached the sheet for more help.

[JOHN H. DAVIS]

You're layout doesn't represent what you said. You have 4 sheets. "Reg Search" - OK. "RegBuilder", "Tuesday.." and "Schedules". In which sheet should we search (all the headers and columns do not coincide) and return the data you want? Also the data you requested in Post 1, is not the same as the header information on these sheets? Your request was to search each sheet and the layout would be the same for all sheets. Are there sheets you want too exclude? Please clarify.

[Shellybelly]

the data should be pulled from the sheets with the date names. everyday there will be a new sheet with a date name. The macro should look through the entire workbook except regbuilder, reg search and schedules and return data found in the sheets with the date name.

[JOHN H. DAVIS]

Test this with some names to see if it does what you want.

Please Login or Register  to view this content.

[Shellybelly]

Thanks alot....you save me some time big time

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as solved.