Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 36

Thread: Distribute ranges as per Plan

  1. #21
    Member Charles's Avatar
    Join Date
    Aug 2012
    Posts
    63
    Rep Power
    12
    Hi,

    Not a problem. Go ahead and attach it.

  2. #22
    Member ayazgreat's Avatar
    Join Date
    Mar 2012
    Posts
    86
    Rep Power
    13
    Please find attached workbook and run macro and see result , Can you make some some changes in it and get required result as mentioned in my first post attached workbook
    Attached Files Attached Files

  3. #23
    Member ayazgreat's Avatar
    Join Date
    Mar 2012
    Posts
    86
    Rep Power
    13
    Charles have got any development

  4. #24
    Member Charles's Avatar
    Join Date
    Aug 2012
    Posts
    63
    Rep Power
    12
    HI,

    Sorry to say I do not have a answer. The file you sent has code that I've seen before, but I do not truly
    understand its operation. And from what you want it may be beyond my ability.
    But I'll still continue with this. Hopefully another member may be able help.

  5. #25
    Member ayazgreat's Avatar
    Join Date
    Mar 2012
    Posts
    86
    Rep Power
    13
    Is there any other member, who can resolve it ?

  6. #26
    Member Charles's Avatar
    Join Date
    Aug 2012
    Posts
    63
    Rep Power
    12
    Hi,


    I modified my code.
    Check it and let me know what and where its wrong and how to determine the solution to resolve it.
    Attached Files Attached Files

  7. #27
    Member ayazgreat's Avatar
    Join Date
    Mar 2012
    Posts
    86
    Rep Power
    13
    Thank you very much for your efforts, there are still some error regarding to same prefix breakup of range, I have marked and explained these errors in attached file which are in result sheet in row number B25 & B49.
    Attached Files Attached Files

  8. #28
    Member Charles's Avatar
    Join Date
    Aug 2012
    Posts
    63
    Rep Power
    12
    Thanks, I'll take a look.

  9. #29
    Member Charles's Avatar
    Join Date
    Aug 2012
    Posts
    63
    Rep Power
    12
    Hi,

    I think I see what you want.
    I'll see if I can work something out.

  10. #30
    Member ayazgreat's Avatar
    Join Date
    Mar 2012
    Posts
    86
    Rep Power
    13
    Is there any progress ? Could someone else solve it please ?
    Somthing is better than nothing

Similar Threads

  1. Replies: 5
    Last Post: 05-28-2013, 03:00 AM
  2. Intersection of Overlapping Ranges:Space Operator
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM
  3. List all the name ranges in an excel sheet with scope
    By LalitPandey87 in forum Excel Help
    Replies: 4
    Last Post: 03-28-2012, 07:27 AM
  4. Delete Name Ranges by Scope VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 12-20-2011, 03:54 AM
  5. List Unique/Common Values From Two Ranges
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 09-16-2011, 08:34 AM

Posting Permissions

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