Re: Data storage/retrieval

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

i appreciate your assistance here is the scoop

I need to track the progress of 7 production measureables every 2 hours.
Workbook has three tabs, Shifts 1, 2, 3 for each shifts supervisor to enter
the progress observed every two hours.
Working files field names are by column. All entered data would be in same
column. (except date). 7 measureables Column A, Column B there are four cells
to enter data (2 hour interval progress over 8 hour shift) per measureable,
at least 28 cells of data to transfer to a running data table every shift.
This table does not have to be in the same workbook but will that simplfy
things? Your call

using somekind of 'update and clear' macro will allow the supervisor to use
the same file instead of a new one/save as every day, but also store that
info so that daily, weekly, monthly reports can be used.

The reason I am not just simply having them input this data into one single
table is due to the fact that the next two columns C & D have specific cause
and fail codes that are chosen from a drop down box. This data too will need
to be compiled but would be very similar to the progress cells that are of
interest right now.

Instead of using a workbook close command, would a command/action button
"Update" work so that the supervisor can enter info into one of the shift
tabs throughout the day but not actually transferthe data to the file until
the End of Shift (8th hour) production status has been entered and the
"Update" button clicked.

looking forward to discussing with you,

thanks
Adam

"Otto Moehrbach" wrote:

Yes, you would need a macro for that. From what you say, maybe a
Workbook_BeforeClose macro would work for you. That macro will fire
whenever the user issues a Workbook Close command (perhaps at the end of the
day?). The code in the macro can be written to do whatever you want done.
If you think this would work for you, post back and provide a bit more
detail about the layout of your data, what you want copied/pasted and the
layout of where you want it pasted. HTH Otto
"Adam" <Adam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A7FBC480-98B5-4FCC-B56F-75775496DDB8@xxxxxxxxxxxxxxxx
I would like to set up an excel file that has several tabs that send data
to
one table, but on a daily basis clear the data in those tabs to enter new
info while continuing to add/store that data to the master data table.

First three being, say 1, 2, 3. Data will be entered into those file
fields.
I want to be able to send that data to a running summary table ie by rows.
for that day. For day 2 I want to use the same 1,2,3 tabs to enter in new
info and at the same time still have that data linked to that table. etc
continue to clear the entered info but update a master table.

Does this involve macros or can I only do this through controls and
database
functions.




.

Relevant Pages

  • Re: Actual Work moving to future
    ... > level progress entries from recording the work performed. ... I think of resource in that context as meaning skill set. ... > shows a day shift, ...
    (microsoft.public.project)
  • Re: Actual Work moving to future
    ... > level progress entries from recording the work performed. ... I think of resource in that context as meaning skill set. ... > shows a day shift, ...
    (microsoft.public.project)
  • Re: Calculations
    ... Chip Pearson has a progress bar at www.cpearson.com ... >> I have written a macro which performs some lengthy calculations. ... I want to display a progress ...
    (microsoft.public.excel.programming)
  • Re: % Complete
    ... I am looking to extract the progress of % complete for a block of tasks. ... > Project data field or custom calculated value can be exported as ... > timescaled information to Excel. ... > all data the formatting in Excel can also be customized with the macro ...
    (microsoft.public.project)
  • Macro works in 2000 not XP for Progress Bar
    ... The Following macro works in Excel 2000 but not Excel XP ... Note that if I dont unload" the Progress Bar it will show ... Sub UpdateProgress ...
    (microsoft.public.excel.programming)