How to do an automation for copy paste, added new row (macro)
Hello
I have attached file
I want to automated a some step (tab table Z)
Thus, for example, that in X 2012:
1) I want to copy D16:E16
2) added a new one blank below before the paste D17:E17
3) converted the 2011 to 2012 in cells D17: E17 (ctr+h function find 2011 replace the 2012)
and by analogy, 1) 2) 3) for Y
And just every year
In the point 3) conversion step, it can converts the 2011 to 2012 or 2010 to 2012 as comfortably.
Regards. Thank you in advance for your answer
| Attachment | Size |
|---|---|
| 1.xls | 13.5 KB |

Recent comments
7 years 25 weeks ago
8 years 10 weeks ago
8 years 22 weeks ago
8 years 25 weeks ago
8 years 26 weeks ago
8 years 32 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago