Results 1 to 4 of 4

Filling in a long-term table from a single, changing source

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-13-2014
    Location
    Kansas City, Missouri
    MS-Off Ver
    Excel 2013
    Posts
    125

    Filling in a long-term table from a single, changing source

    So this is going to be a little difficult to explain, because there are multiple moving parts.

    We have operators who are currently filling out either hand written or simple excel time cards. These time cards then have to be manually inserted into a comprehensive tracking sheet for individual jobs.

    At one point, with the help of people on this forum, I designed a single excel file, with one tab containing 50 sheets of time cards, and a second tab which contained the tracking sheet, and pulled from the excel.

    People identified two problems:

    1. They don't like the 50 sheets of time cards on one tab - but having 50 tabs isn't acceptable either. In an ideal world, there would be one time card sheet, but right now it's 50 because the tracking is set up to pull from individual points from the time cards.

    2. Having 50 time cards on one tab makes it difficult for operators to print pdfs of individual ones... even though it's rather easy, since they're set to be a page each, and they just have to print the appropriate pages...but whatever.

    So... the minimum of what I need to happen:

    A single time card that somehow can input information onto a tracking sheet on another tab, but then can be 'reset' to a blank time card without removing the data that's been inserted on the tracking sheet.

    I have -no- idea how to do this, but I can imagine something created with an upload button.. So they fill out the time card, 'upload' it to the tracking sheet, and then can save that time card as an individual file for that day, then blank it for the next day - all very easily. These are very computer illiterate people..

    Help me think outside the box here... I know this is very complex, but it would help us tremendously if we could make it work, because we spend -way- too much time taking time cards and inserting them manually into tracking.

    I'll upload what I created, since I know this may be confusing without it:
    Attached Files Attached Files
    Last edited by Drayde; 07-24-2014 at 11:52 AM. Reason: Improper title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sending complex types in Soap Web Services Request
    By johannvivot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2012, 02:58 PM
  2. Complex Spreadsheet build request
    By Mike Church in forum Excel General
    Replies: 1
    Last Post: 02-04-2012, 01:05 AM
  3. Complex formula request... or so it seems!
    By zvezdana in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-23-2007, 10:34 PM
  4. Difficult protection request
    By Siberian in forum Excel General
    Replies: 1
    Last Post: 06-24-2006, 11:49 PM
  5. Difficult look-up request
    By natejohns7 in forum Excel General
    Replies: 2
    Last Post: 02-15-2006, 07:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1