+ Reply to Thread
Results 1 to 3 of 3

Need to be able to input a name in Sheet2 and pull rows from Sheet1 based on that name

  1. #1
    Registered User
    Join Date
    10-15-2012
    Location
    tampa
    MS-Off Ver
    Excel 2003
    Posts
    3

    Need to be able to input a name in Sheet2 and pull rows from Sheet1 based on that name

    I have a spreadsheet of employees with their managers and other data. I want to be able to hide sheet1 with all data and provide the managers the spreadsheet so they 1) see only sheet2, 2) enter their name in A1 and all their employees list below.

    Is this possible?

  2. #2
    Registered User
    Join Date
    10-15-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Need to be able to input a name in Sheet2 and pull rows from Sheet1 based on that name

    possible Provide a dummy excel sheet.

    Regards

    Babu

  3. #3
    Registered User
    Join Date
    10-15-2012
    Location
    tampa
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Need to be able to input a name in Sheet2 and pull rows from Sheet1 based on that name



    I want to hide and protect the 1st sheet and be able to send workbook out to managers so in 2nd sheet they can type their name, or pull from a drop down, and only their employees show, the entire row of data on each employee.

    I appreciate any insight you can provide.
    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)

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