Excel +Collation for statistics?

O

olly

Hi guys
I've got a worksheet which reports delays in a department of a
certain product-basically a delay reportin mechanism-allowing the user
to enter product code, order reference etc. Only one delay will be
reported per delay report, so there will be many delay reports at the
end of each month. One thing-is there any *simple* way of collating
all the separate MS Excel delay reports everymonth, into one
spreadsheet, for analysis (i.e graphs/stats) ? The main format of the
spreadsheet are 3 form drop boxes which look up from an adjoining
sheet, and a few other fields like date and name, for which the user
enters.
Any feedback greatly appreciated
Olly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top