Hi Forum,
I have a large amount of data that I would like to cut chunks out of and paste together in another worksheet.
The header for the data looks like this:
year month day minute temperature
and the data ranges from 4/2008 to 10/2010.
In another table, I have a list of months that I'd like to piece together in order:
month year
1 2010
2 2009
3 2010
4 2010
5 2008
...
12 2009
My goal is to make a full year of data, where the January comes from the 2010 January data of the main dataset, the February from the 2009 February, and so on, according to my list.
I could do it by hand, but I would like to automate it because I have to do it many times over with different lists.
My first question is whether I should use a VBA sub or not. If I should, I'm not sure where to start. I would be grateful for any recommendations.
Thanks!
Mary
Bookmarks