#1
|
|||
|
|||
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 Last edited by jpol; 03-01-2013 at 06:11 AM. |
#2
|
||||
|
||||
Cross-posted at: http://www.tek-tips.com/viewthread.cfm?qid=1705501
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
copy and paste not working | Ellie | Word | 3 | 11-07-2013 02:23 PM |
Word counting macro for newly added portion? | New Daddy | Word VBA | 24 | 09-30-2013 07:30 PM |
Copy and paste disabled | Jennifer Murphy | Word | 1 | 01-09-2013 05:36 PM |
Can't copy paste | irenasobolewska | Office | 2 | 10-26-2012 05:09 PM |
Copy/Paste Question | rcdeacon | Word | 2 | 12-20-2008 09:11 AM |