Results 1 to 7 of 7

Excel Tracking Sheet Help...

This is a discussion on Excel Tracking Sheet Help... within the Excel Questions forums, part of the Question Forums category; Hi there! I need some help with a project here at my work. I've never done anything this complex with ...

  1. #1
    New Member
    Join Date
    Jul 2003
    Location
    Indianapolis
    Posts
    5

    Default Excel Tracking Sheet Help...

    Hi there! I need some help with a project here at my work. I've never done anything this complex with Excel before and I'm stuck. I can't figure out the proper syntax for what I want to do. I have a list of data organized in columns by the title of that column. This makeshift database is just a second worksheet within the same book. I need the first worksheet to reference the second worksheet when a piece of data is entered onto the first sheet. Essentially, I need Excel to look at the data entered in column A of the first sheet, reference the entire second sheet, and when it finds a match, populate column B with the title of the column the data is found in on the second sheet. All the entries made into the first sheet will be listed on the second sheet but the column they are listed in may change from time to time. I'm so close to getting it but I feel like I'm missing some tiny obvious thing.

  2. #2
    Board Regular golf4's Avatar
    Join Date
    Jul 2002
    Location
    Salem, OR
    Posts
    452

    Default Re: Excel Tracking Sheet Help...

    Hi, Eric -

    I read your query, and it sounds as if VLookup may be of help to you. You may want to look in the Help directory of XL or do a search for VLookup on the Board. I have used it myself, and it works great. Plus, the users on this board are absolutely fantastic when it comes to asking and obtaining help.

    HTH.

    Golf

  3. #3
    New Member
    Join Date
    Jul 2003
    Location
    Indianapolis
    Posts
    5

    Default Re: Excel Tracking Sheet Help...

    Hey thanks, I'm checking that out now...I'll post if I figure it out.

  4. #4
    Board Regular Jaafar Tribak's Avatar
    Join Date
    Dec 2002
    Location
    Larache--Morocco
    Posts
    4,965

    Default Re: Excel Tracking Sheet Help...

    Hi,

    I assume that the Second Sheet is called SecondSheet and that there are no Duplicates values in it.

    I also assume that the Titles Row is Row2. Adjust to suit your data arrangement.

    Right click the first sheet tab, select View Code and paste the following code:


    Private Sub Worksheet_Change(ByVal Target As Range)

    Dim Mtch As Range
    Const TitlesRow = 2
    If Target.Cells.Count = 1 Then
    ****If Target.Column = 1 Then
    ********With Sheets("SecondSheet")
    **********Set Mtch = .UsedRange.Find(Target, LookIn:=xlValues)
    **********Target.Offset(0, 1) = .Cells(TitlesRow, Mtch.Column)
    ******** End With
    ****End If
    End If

    End Sub



    Hope this helps.
    Office/Excel 2007 Win XP

    Common sense is not so common.


    http://photo-larache.blogspot.com/

  5. #5
    New Member
    Join Date
    Jul 2003
    Location
    Indianapolis
    Posts
    5

    Default Re: Excel Tracking Sheet Help...

    I'm just an idiot I guess, but having never used this functionality before, I'm struggling with the proper syntax. I need to make a tracking sheet to manually track the text I.D. of each person I talk to. That person is on a team and that team has a team leader. I need to be able to enter the text I.D. of the person I'm helping in column A and have Excel search the I.D. database and populate column B with the text I.D. of that person's team leader. I have the team data arranged in columns with the name of the team leader at the top of the column. Conceivably, I could keep all the team leader's I.D.'s in the same row and just have the I.D.'s of their team listed beneath. I can't figure out how to have Excel search multiple columns for the data I need to match.

  6. #6
    New Member
    Join Date
    Jul 2003
    Location
    Indianapolis
    Posts
    5

    Default Re: Excel Tracking Sheet Help...

    I'm just an idiot I guess, but having never used this functionality before, I'm struggling with the proper syntax. I need to make a tracking sheet to manually track the text I.D. of each person I talk to. That person is on a team and that team has a team leader. I need to be able to enter the text I.D. of the person I'm helping in column A and have Excel search the I.D. database and populate column B with the text I.D. of that person's team leader. I have the team data arranged in columns with the name of the team leader at the top of the column. Conceivably, I could keep all the team leader's I.D.'s in the same row and just have the I.D.'s of their team listed beneath. I can't figure out how to have Excel search multiple columns for the data I need to match.

  7. #7
    New Member
    Join Date
    Jul 2003
    Location
    Indianapolis
    Posts
    5

    Default Re: Excel Tracking Sheet Help...

    You are the man Jaafar. That was it exactly. I'm extremely impressed with the speed and accuracy of this info. I'm almost speechless. Thanks to everyone who posted to try and help me. Once again, major praise for Jaafar... You Are The Man!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com