Recognize text from main sheet and sorting to others.

[hello44]

Hi everyone,

I'm trying to get my workbook to automatically send certain information from my "combined" master sheet to other sheets within the workbook. I would like the program to recognize the initials of certain individuals in column C and place the information in that row on their corresponding sheet. I would also like to sort the Area in column D to the corresponding sheets. Column C is the workers initials 'KB' and the corresponding worksheet for this guy is Kevin Bu...

Im copying and pasting at the moment and I know there is a better way. I've been searching for a few days and cant seem to get the formulas correct.

Any help greatly appreciated. I have attached the file.

Cheers
Brent

[p24leclerc]

What you are looking for is not doable with formulas. You'll need VBA macros for sure.
Do you really need the blank row between dates? It can be a real problem.

[hello44]

No i dont need the blank row. i have tried vlookup but it adds multiple entries of the same data.

[hello44]

Sorry I have attached without blanks. thanks a lot for the response.

[hello44]

my apologies..i guess it did not save previously.

[hello44]

Field Weld Log by Fuser.xlsx. sorry for all the messages,

[p24leclerc]

By using initials only, this means you'll have to take great care of your sheets' name as you don't want to have a sheet named like "Flange Torques" that would return FT as initials that could be a fuser initials. Why don't you use the whole fusers' name in the Combined sheet as it is in the sheets names?

Also, why do you want to duplicate all of your information? You have it all in the Combined sheet. Why don't you use filters to view only one fuser at a time? You can also set filter for dates and many other valuable things.

[azumi]

Maybe something like this? Please check the file.....