Hello,
I have a problem that I think can be solved with a macro, but im not sure where to start.
I have a number of spreadsheets that are set up with varying amounts of data from several sites, with header information followed by the data. I want to take one part of the header info (station number), copy it into another sheet, and then copy the data so that each row becomes associated with the station number. And then repeat with the next station so i get a complete list with just the data and none of the extra header records.
I have an example sheet showing the original data and the desired output here:
http://homepage.ntlworld.com/steven.lee717/TrialSheet.xls
Ideally the Date and Time columns (B&C) in the output would be combined as shown in Column H, but I can live without that if its not easy to do.
Furthermore, if I could set it running on a number of individual sheets saved in a folder at once that would be fantastic.
Thanks for any help anyone can offer!
I have a problem that I think can be solved with a macro, but im not sure where to start.
I have a number of spreadsheets that are set up with varying amounts of data from several sites, with header information followed by the data. I want to take one part of the header info (station number), copy it into another sheet, and then copy the data so that each row becomes associated with the station number. And then repeat with the next station so i get a complete list with just the data and none of the extra header records.
I have an example sheet showing the original data and the desired output here:
http://homepage.ntlworld.com/steven.lee717/TrialSheet.xls
Ideally the Date and Time columns (B&C) in the output would be combined as shown in Column H, but I can live without that if its not easy to do.
Furthermore, if I could set it running on a number of individual sheets saved in a folder at once that would be fantastic.
Thanks for any help anyone can offer!