+ Reply to Thread
Results 1 to 8 of 8

Recognize text from main sheet and sorting to others.

  1. #1
    Registered User
    Join Date
    03-31-2014
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    5

    Recognize text from main sheet and sorting to others.

    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
    Attached Files Attached Files

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Recognize text from main sheet and sorting to others.

    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.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Registered User
    Join Date
    03-31-2014
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Recognize text from main sheet and sorting to others.

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

  4. #4
    Registered User
    Join Date
    03-31-2014
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Recognize text from main sheet and sorting to others.

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

  5. #5
    Registered User
    Join Date
    03-31-2014
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Recognize text from main sheet and sorting to others.

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

  6. #6
    Registered User
    Join Date
    03-31-2014
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Recognize text from main sheet and sorting to others.

    Field Weld Log by Fuser.xlsx. sorry for all the messages,
    Last edited by hello44; 04-01-2014 at 12:03 AM.

  7. #7
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Recognize text from main sheet and sorting to others.

    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.

  8. #8
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,261

    Re: Recognize text from main sheet and sorting to others.

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copying from main sheet to new sheet if cell contains certain text
    By fitzegee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2011, 08:10 AM
  2. [SOLVED] Re: How do I link cells, sheet to sheet, to recognize row deletion
    By Max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-27-2006, 06:35 PM
  3. Replies: 28
    Last Post: 02-27-2006, 06:35 PM
  4. Replies: 1
    Last Post: 05-24-2005, 06:31 AM
  5. Replies: 1
    Last Post: 05-24-2005, 06:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1