+ Reply to Thread
Results 1 to 7 of 7

Selecting Worksheet based on User Input.

  1. #1
    Forum Contributor
    Join Date
    05-19-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    107

    Selecting Worksheet based on User Input.

    Hello all,
    I currently have a workbook with a dozen or so worksheets with employees names and stats on them. I am trying to use an inputbox where the user puts in an employee name and it will go to that worksheet and copy the data that I need.

    Please Login or Register  to view this content.
    Last edited by CJPHX; 05-25-2010 at 02:57 PM.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Selecting Worksheet based on User Input.

    This requires a little error checking:
    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Forum Contributor
    Join Date
    05-19-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    107

    Re: Selecting Worksheet based on User Input.

    Thank you that worked great. Now I just need to have it select from A2:C2 and then copy all the data down based on what is in column B.

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Selecting Worksheet based on User Input and Auto Copy Data until last row.

    Copying is easy, but your only halfway there explaining it. Can you elaborate more detail?

  5. #5
    Forum Contributor
    Join Date
    05-19-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    107

    Re: Selecting Worksheet based on User Input and Auto Copy Data until last row.

    I am attaching a worksheet with what my data sheets look like. Column is numbered down a ways for projected work for the day. However if the work through less acounts the data in columns B through E is different. I don't need Row 1 copied as it is column headings. I need it to copy A2 over to E2 and then down all the way based on what column B has data in.
    Attached Files Attached Files

  6. #6
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Selecting Worksheet based on User Input and Auto Copy Data until last row.

    Got a before/after example?

  7. #7
    Forum Contributor
    Join Date
    05-19-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    107

    Re: Selecting Worksheet based on User Input and Auto Copy Data until last row.

    I added a couple more worksheets to show what it looks like before and after. The before sheets I background in yellow the fields I want it to copy. I then want that info pasted into the After sheet in the next empty row.

    **It will not let me upload the file this time. It just goes and goes. I will try agian in a few minutes.***

    Based on the sheet I previously uploaded I can tell you that even though Column A has data all the way down to Row 15. I only want it to copy down to Row 3 as I am not interested in the empty ones where no account information is listed. I do need the info from A:E though starting at Row 2 down.
    Last edited by CJPHX; 05-25-2010 at 02:05 PM.

+ 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