|Ok, first of all I'm new to your site and WOW! I am incredibly impressed with the wealth of knowledge I've come across while searching through various forums! I've already found all kinds of great macros and ideas that will make my workload a lot easier. |
That being said, I have a problem with efficiently sorting some data and I hope one of you macro gurus can assist :)
I've found several macros that do something similar to what I'm looking for, so hoping to get something a little more specific. Basically, I have some weather equipment that monitors up to 5 things in the air and then transmits data to my computer via radio, and spits out text files that I then copy into excel. It creates one text file for each thing I'm monitoring. The format is:
Date (mm:dd:yy:hh:mm:ss), WhatIsMonitored, Unit#, Concentration
So for example if I'm using this equipment to monitor the concentration of oxygen in the air over the course of a couple minutes using just one unit (and by unit I mean the machine that is doing the monitoring), it will give me something like:
So for in this case it's not too much trouble to just copy the text into Excel, then use the "text to columns" feature to put it in columns.
The problem I'm running into is when there are multiple units running at the same time, each monitoring up to 5 different things... and they might run continuously for a week or more at a time. The text files are generated based on whatever you're monitoring, so again using the same example with checking JUST for oxygen I'd get one text file that would include one long column of data with the aforementioned data for each unit. So something like:
Like I said it generates one text file per thing you're monitoring, so I'm assuming if anyone can come up with a macro to sort one thing, it will work just as well on another. As it is, I have to go through these worksheets line by line cutting and pasting the data from each unit to it's own separate sheet...
So in a nutshell, what I'm looking for is a macro to sort this data into separate sheets by date and Unit# (i.e. from the previous example text file data it would be put into 4 sheets: 09-01-2010 Unit 10, 09-01-2010 Unit 11, 09-01-2010 Unit 12, and 09-01-2010 Unit 13.
This seems very confusing and hopefully I've explained the problem adequately for one of you excel brainiacs to help me out with a solution. And please let me know if I can make things clearer or you require more information. Thanks a million!