+ Reply to Thread
Results 1 to 1 of 1

copy specific range of rows and columns according to a cell value

  1. #1
    Registered User
    Join Date
    09-02-2012
    Location
    Bulgaria
    MS-Off Ver
    Excel 2010
    Posts
    19

    copy specific range of rows and columns according to a cell value

    Hello,

    i'm trying to build a macro and assign it to a button to:


    - copy/paste selection value
    from sheet1 range A2:E4 based on a number in colomn F(cell F2)
    to sheet 2
    - copy/paste selection value
    from sheet1 range A5:E7 based on a number in colomn F(cell F5)
    to sheet 2

    and continue like this.

    if there is nothing in colomn F(cell F..) just to pass it and move forward.

    for copying i want to be copied like this in sheet 2
    for example
    5 times for A2:E4 range from sheet1
    2 times for A5:E7 range from sheet1
    to copy like this in sheet 2
    1.1-A2:E4
    1.2-A5:E7
    1.3-A8:E10
    1.4-A11:E13
    1.5-A14:E16
    2.1-A17:E19
    2.2-A20:E22

    Thank you very much in advance for the time and help.

    Best Regards
    D.D.
    Last edited by archangel9999; 02-26-2013 at 04:18 PM.

+ 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