+ Reply to Thread
Results 1 to 3 of 3

Copy / delete ranges in specific order

  1. #1
    Registered User
    Join Date
    09-19-2013
    Location
    CZE
    MS-Off Ver
    Excel 2010
    Posts
    9

    Lightbulb Copy / delete ranges in specific order

    I am new to VBA and would like to learn from you. Have a look at this sample file:example_copy_delete_ranges.xlsm
    My task was to add buttons to "Master" sheet that would copy / delete colored areas from sheets "green" and "red". The final document should have the structure like the one in "example" sheet.

    Conditions:
    - all green fields have to always be above the red fields
    - the order of colored fields has to be maintained (when deleting one green/red field, only the last from the color added should be deleted; when adding new green/red, it must be added right behind the last of the same color)
    - all options must be possible (only one or more reds / only one or more greens / both reds and greens / none)

    I managed to do some of the coding, but it is not working properly in some cases. (And I lamely added some letters and numbers behind the colored fields that could be displayed in white, which would not be seen then. I did not manage anything without them.)

    If anyone would be able to solve this neatly, I would love to look at the file (code) and learn from it.
    Thank you!

  2. #2
    Registered User
    Join Date
    09-19-2013
    Location
    CZE
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Copy / delete ranges in specific order

    Or is it difficult to solve according to your opinion?

  3. #3
    Registered User
    Join Date
    09-19-2013
    Location
    CZE
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Copy / delete ranges in specific order

    Anyone to accept this challenge?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to Delete Named Ranges in A specific Sheet
    By Romulo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-12-2013, 08:05 PM
  2. copy and paste columns in a specific order on a different excel sheet.
    By milkfloat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2013, 01:36 PM
  3. [SOLVED] Copy columns by header value and paste them in a specific order into another workbook
    By KeriM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2012, 11:13 AM
  4. Copy and paste/ delete ranges from mulitpuls sheets macro
    By girt0n in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2012, 08:23 AM
  5. copy specific ranges based on certain values
    By WhiteKelso in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2008, 09:55 AM

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