How to store data on different excel sheets and lines based on "date" and data gathered from a source.
Posted on 2005-03-25
I have created code to get the data in and place it on sheets in a specific format, now i need figure out how to automate the process.
Importing data from other systems. Here is what i need to do.
Gather the data (data storage date) (Data storage time) (Data itself)
Decide based (Data Storage Date) what spread sheet to store data into (Janurary thru December)
Then decide which cell areas to store data into based on the (data storage Date)
In The end, each monthly spreadsheet would have a filled out sheet for the month and have gathered all of the proper values and time for each day.
This data could be printed out as just a data sheet or some sort of graph depending on the my needs.
I have wants for this data to collect data on cooling, power consumption, totalization and peak power readings and peak times.
Everything revolves around sample dates and times.
PS using excel from office 2000 thru 2003. Greg