Greetings. I'm finding this tricky but you guys may think it is easy.
Basically i have 8 years of monthly data in row format in excel (96 rows). Beginning at the end of the third year (i.e. moving down the row 36 cells) i need to move forward 1 cell at a time and copy and paste each 36 monthly period. i.e. my original data is from March 02-Feb '10. beginning in April '05 i need to select 3 years (to March '08) and past this block of data 3 cells below the original data. i then need to move forward 1,select May '05, select those 36 months and paste them 3 cells below the previous range. The data gets updated monthly so instead of copying and pasting each month is there a code that makes this very quick
My (poor attempt)....
any help would be gratefully appreciated.
Thanks!!
Bookmarks