walruseggman,

That code works perfectly! Thank you so much for your timely response.

jaslake,

I'm not sure what you mean by a User Input Form. Were you thinking of an Access database with a form that feeds into this spreadsheet? That would definitely be beneficial when I'm not the one entering data, but I wouldn't know how to do it. For now I'm the only one that'll be entering data, though, so just using the spreadsheet will be sufficient.

I haven't settled on the exact format for the spreadsheet yet. It will be viewed by people other than myself, so I'll need to make it user friendly. If it were just for my record keeping it would stay exactly as it is now. If I could have a database take data, then send it to a spreadsheet which contains several sheets (raw data, per-analysis data, a summary giving only the output of each type of analysis) which will then run basic calculations and print a response into, say, another database form so I can print it, this would free up my time for more demanding tasks.

So I'm not sure if, in the end, the sheets will still be named as they are. I should think so, since I need to have each plant from which I receive material in a different sheet to allow me to run quantitative analyses. At least, that's how I thought it would be easiest to make. As for the headers - those were only included for readability. I don't need them to repeat in a sheet in which calculations are performed.

The plant will operate around the clock 6 days a week, so the averages will be calculated for a 24 hour period. Could a daily average be automatically calculated each time the spreadsheet is opened for the previous 24 hour period and sent to a cell in another sheet?


I'm not familiar with the protocol for this forum, so should I keep this thread open or mark it as solved and post a new thread with my new questions?