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:

Here is a concept for you, my sheet design is not similar to your in any way I am just posting it as a method you can alter to suit your needs.

This file uses a macro to copy data from one place to another (from Entry to Database), it also clears out the original data area once the data is copied.

The data on the Database table (the bottom half of the sheet, it would be its own sheet in your application) can then be pivot tabled to find any details you need to find, or a single page with formulas can be created if you are trying to make a printable report on a given employee

Like I said, this is just an idea for you, not the final product. Sounds like a fun project, hope you get it working!

saving.xlsm

Add as many fields as needed, adjust the code to fit the requirements (ALT+F11 to bring up VBA code, it is in Module1)

Originally Posted by Drayde

I'll take a look at it, Speshul, thanks. I am not at all a coder or even incredibly familiar with the deeper complexities as well, so this is way out of my league, but I learn quickly and am just going to play for awhile and see if I can't figure something out.

But, I would love suggestions/ideas from people. Often someone comes up with a process I had never thought of.

To achieve what you are looking to do (clear out data on an input sheet and save it to another sheet for records), it has to be done in VBA, there are no formulas that can achieve this type of automation :\

I'm no VBA coder myself, but the language itself is fairly easy to understand and mess with, and there are a LOT of good coders on Excel forum who would be happy to help you out!