+ Reply to Thread
Results 1 to 1 of 1

How to do an automation for copy paste, added new row? (macro)

Hybrid View

  1. #1
    Registered User
    Join Date
    03-31-2012
    Location
    Warszawa
    MS-Off Ver
    Excel 2013
    Posts
    32

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1