an automation for copy paste, added new row (macro)

Skip to first unread message

artforart artforart

Mar 2, 2013, 2:31:18 PM3/2/13
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.

PS: I've got some macro cod. But there is some problems
1) with loop macro:
I use macro only for sheet: table Z. When I start macro then added me next year below from source date. For example when I want to got 2012 I added a source date - new sheet 2012 (in attachment is ready added) and I start macro etc. every years. When I want put 2014, It is something wrong (loop don't working)
2) After used macro the formula bar (table Z) is lost.( formula bar show a source date)

U have any cod, idea ? write boldly. If someone wants to test this cod. I can send it also.
Regards. Thank you in advance for your answer
Reply all
Reply to author
0 new messages