Results 1 to 2 of 2

Thread: Importing Spreadsheets

  1. #1
    Newbie
    Join Date
    Jul 2005
    Posts
    4

    Thumbs up

    (I am not sure where to ask this question. I am thinking the Access forum would be better than Excel, but could be done in both.)

    I am working with 5 other people for an Architect, and I have designed separate bi-weekly time sheets in Excel. The spreadsheets are set up to calculate the time spent on each project a person does, vacation and holiday time, and then give a total at the bottom.

    Here's my questions: Is there anyway that Access or Excel can take a person's time and the client each person works on, and put it in a single spreadsheet to show how many hours each client has? For instance, 2 other co-workers are doing work on the same project I am, and the architect wants to know how much total time was spent for this client.

    What he really wants to see is column A list the job number; Column B list the client; Columns C - H be for the employees, and Column I be for the total times. Of course, down at the bottom of Columns C - H would be totals for each employee.

    Any ideas how this can be accomplished and which program (Access or Excel) would work best?

    Thank you in advance for your replies!
    Dan

  2. #2
    Senior Member RickDev's Avatar
    Join Date
    Jul 2005
    Location
    Melbourne, Florida
    Posts
    438
    Posted a reply in the other forum
    RickDev
    "Nobody knows what I do until I stop doing it."

    Florida Web Design | Online Geek Hangout | Office Pranks and Humor

Similar Threads

  1. Importing .csv contacts into Evolution
    By JoeyJoeJoe in forum Linux - Software, Applications & Programming
    Replies: 0
    Last Post: 05-05-2007, 03:01 PM
  2. Duplicate emails after importing pst
    By jonfa in forum Windows - General Topics
    Replies: 0
    Last Post: 08-04-2006, 09:06 AM
  3. Importing Spreadsheets
    By Dannoboone in forum Windows - General Topics
    Replies: 3
    Last Post: 07-24-2005, 07:19 PM
  4. Error Importing XML Files
    By regix in forum Windows - General Topics
    Replies: 0
    Last Post: 01-04-2005, 01:48 AM
  5. Importing old thunderbird e-mail
    By mcdougrs in forum Linux - Hardware, Networking & Security
    Replies: 3
    Last Post: 10-29-2004, 01:31 PM

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
  •