Results 1 to 2 of 2

cut bordered range depending on contents inside range

Threaded View

jordan2322 cut bordered range depending... 05-22-2012, 06:14 PM
jordan2322 Re: cut bordered range... 05-26-2012, 07:23 AM
  1. #1
    Forum Contributor
    Join Date
    11-16-2011
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    405

    Question cut bordered range depending on contents inside range

    Hi everyone,

    I have ranges in column C that have borders around them. The number of Rows for each range is unique and varies week to week.

    I need a macro that looks over the entire used range in column C for these borders, and depending on how many cells below the Top border have values in them Cuts the range from Column C into a different column at the same Row number.

    There are only 4 possibilities that can occur:
    1.
    There is only 1 cell below the top border that has a value in it. i.e. 2 cells below the top border there is no value in the cell.
    Outcome: Cut Range between Top and bottom Border from Column C to Column B.
    2.
    There are 2 cells below the top border that have values in them. i.e. 2 cells below the top border have a value in the cell however the 3rd cell contains no value.
    Outcome: Do nothing, continue on with next range
    3.
    There are 3 cells below the top border that have values in them. i.e. 3 cells below the top border have a value in the cell however the 4th cell contains no value.
    Outcome: Do nothing, continue on with next range.
    4.
    I would also like to allow for special provision values that move when found. I.e. when the term "Jordan" is found in the 2nd cell down from the top border then cut the range from column C to Column A

    Once the Cell has been cut to its destination column (or not cut in the case of possibilities 2, and 3) then the range should be filled white
    between the Column C and the destination Column. With all inside borders removed and a outside continuous border applied.

    thanks !!
    regards
    Attached Files Attached Files

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