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
Bookmarks