+ Reply to Thread
Results 1 to 5 of 5

Very Basic Question, I Think.

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2003
    Posts
    3

    Very Basic Question, I Think.

    Basically all I want to do is to manage a spreadsheet of new call center hires.
    I just want to have 3 worksheets within this Spreadsheet.
    1. One tab with every employee's information (region where they work, job titles, etc.)

    2. One tab that breaks out the employees by region of the country they work in.
    3. One tab that breaks out the employees by their job titles.


    Basically tabs 2 and 3 should be included WITHIN in Tab 1. I'm just trying to avoid having to enter the data in two places every time someone is hired or fired. Ideally I just want to enter the data in tab one and have some formula automatically sort the data into the two additional tabs.

    Any help is greatly appreciated. The simpler the solution, the better for my small brain!

  2. #2
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Very Basic Question, I Think.

    yes use a vlookup based on a unique identifier number or name, then have Sheet2!a1 = Sheet1!a1 if you delete a person on sheet 1 they will fail the vlookup

  3. #3
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Very Basic Question, I Think.

    also do you just want to sort the data by region on the region tab or do you want to only show people from region x?

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Very Basic Question, I Think.

    Why not just use one worksheet for everything, and then autofilter to see what you want?

    http://www.contextures.com/xlautofilter01.html
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Very Basic Question, I Think.

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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