+ Reply to Thread
Results 1 to 3 of 3

time sheet calculations

Hybrid View

  1. #1
    Registered User
    Join Date
    11-17-2007
    Posts
    28

    time sheet calculations

    Attached is a layout that I am trying to get working.

    the 1st tab is the input sheet, I want to be able to post input on that sheet and have it transfer to the other tabs in the appropriate fields.

    I'm having a problem mostly with the vlookup to get the data into the right cells on the other tabs. Any help would be appreciated, thanks.
    Attached Files Attached Files
    Last edited by DonkeyOte; 02-12-2010 at 03:57 AM. Reason: marked as solved at request of ratcat

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111

    Re: time sheet calculations

    G'day telcotech,

    I've adjust some information and place the formula (INDEX w/MATCH embedded) on the 'incidental' sheet and you can apply the same formula to the others sheets.

    HTH

    RC
    Attached Files Attached Files
    Last edited by ratcat; 02-06-2010 at 11:16 PM. Reason: bad typing
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  3. #3
    Registered User
    Join Date
    11-17-2007
    Posts
    28

    Re: time sheet calculations

    Solved, Thank you very much.

+ Reply to 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