Closed Thread
Results 1 to 5 of 5

Alphabetize List of Names Populated From Multiple Sheets

  1. #1
    Registered User
    Join Date
    12-31-2012
    Location
    Florida
    MS-Off Ver
    Excel 2003 / Excel 2007
    Posts
    6

    Alphabetize List of Names Populated From Multiple Sheets

    Hey y'all -
    Basically, I'm using Excel2007 and trying to create spreadsheet for clients to submit payroll hours etc on. I have one sheet with columns: Name, hourly rate, salary, bonus, etc. with Rows being the Employee. My goal is to have my client fill out a separate sheet with employee info requiring certain fields before entering on the summary sheet with that pay period's hours.

    Any suggestions how to create the summary sheet? Would like the client to be able to select the employee from a Data Validation list type of thing, to then enter their hours etc. The way i started it is by having a summary sheet of all employees (columns being name, addresss, SSN, and all the other info they enter in on the individual info sheet. Hope it makes sense... I'm sure there are more options to accomplish this. ANY insight or suggestions are greatly appreciated. Not opposed to different methods either. Thanks in advance, and hope I posted in correct section.

    I'm not super comfortable with VBasic coding, but am very computer literate and learning code stuff by trial and error.

  2. #2
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Alphabetize List of Names Populated From Multiple Sheets

    albizzundy, welcome to the forum.

    I'm quite sure we can get by without using any VBA, for starters In terms of your master list/summary (of employee information) - is/are your client/s on the same network as you? (Much more straightforward if they are, as you can link their sheets to your master sheet where changes - new employees, etc - can be easily updated.)

    Do you have any work done so far? A started file, maybe with a rough layout etc?
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

  3. #3
    Registered User
    Join Date
    12-31-2012
    Location
    Florida
    MS-Off Ver
    Excel 2003 / Excel 2007
    Posts
    6

    Re: Alphabetize List of Names Populated From Multiple Sheets

    Actually, I would be sending this Excel file to each client for them to send me every pay period when i go to process their payroll. I have a lot of stuff done so far, and probably too much LOL!!! I will attach the file, but don't laugh. I did this very quickly and after a little bit, i start seeing better ways to organize the "checks" etc, but this is all just a guess. Here goes one step for humility.... I will actually have to attach the file later - the server at my office with it on there is actually down for the moment.

  4. #4
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Alphabetize List of Names Populated From Multiple Sheets

    No problem - just be sure to remove any sensitive/confidential data from it.

  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: Alphabetize List of Names Populated From Multiple Sheets

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    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]

Closed Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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