S
StephD
Hello. I receive about 3 production reports each day (each exactly the same
format, each in a new excel workbook) for our machinery, showing which
products were produced, how much material was used, how long production took,
any problems during production, etc.
I would like to create an easy way for the other office workers to
automatically import or copy this information into either an excel or access
worksheet, and then I would like certain graphs, based on this information,
to be generated. The goal is create an almost idiot-proof worksheet which
will automatically generate weekly and monthly summaries/graphs of all our
production data.
The consolidate function in Excel comes close, but it doesn't seem to
include text when I consolidate, it just consolidates numbers.
I don't know Access at all.
Any ideas?
Stephan D.
format, each in a new excel workbook) for our machinery, showing which
products were produced, how much material was used, how long production took,
any problems during production, etc.
I would like to create an easy way for the other office workers to
automatically import or copy this information into either an excel or access
worksheet, and then I would like certain graphs, based on this information,
to be generated. The goal is create an almost idiot-proof worksheet which
will automatically generate weekly and monthly summaries/graphs of all our
production data.
The consolidate function in Excel comes close, but it doesn't seem to
include text when I consolidate, it just consolidates numbers.
I don't know Access at all.
Any ideas?
Stephan D.