I have a large spreadsheet that has column A labeled as "Description" and column B labeled as "Temperature." The "Description" remains constant and "Temperature" changes daily.
I want to write a macro that will take the numerical value based on the cell under "Description" and move them both to a new sheet.
So, for example:
"Description" is Canada and "Temperature" is 58 for day one
then
"Description" is Canada and "Temperature" is 49 for day two
and so on...
The macro should move "Canada" and "58" then "Canada" and "49" to a new sheet and display them in Columns A and B.
Can anyone tell me how to begin writing this?
Thanks