Looking for VBA code, macro or function that will quickly place 'above and below' borders between "like groups of data" driven by what is found in COLUMN (A).
RULES:
1- INDEX, MATCH items in COL A that are alike. Since, A7, A8 and A9 are alike and grouped together based on their Column A content being the same, then
2 -Using the borders feature, put a border line along the TOP of the FIRST INSTANCE of the duplicate number/text, then place a border line along the BOTTOM of the LAST INSTANCE of the duplicate number/text found...
3 - Draw/border that line out through Column D. (I'd like the ability to define what column to end with if possible) because I may want it to extend to Column E or F in some cases to put notes out to the side of that grouping.
Example shown below. Tried to attach sample test file like previously, but not seeing that capability any more?
"BOM Worksheet"
ROW 4....COL A......COL B........COL C..........COL D.......
ROW 5....12345......ELEMENT....$7500.00........25%......
ROW 6....98473......BOLT.........$2900.00........95%......
_______________________________________________
ROW 7....45877......RING.........$2975.00.........85%......
ROW 8....45877......RING.........$2175.00.........55%......
ROW 9....45877......RING.........$2022.00.........15%......
_______________________________________________
ROW 10....34529......ROD..........$1450.00........65%......
ROW 11....61231......SPACER.....$2900.00........85%......
ROW 12....12348......ELEMENT...$6500.00........25%......
ROW 13....98473......BOLT.........$2900.00........95%......
ROW 14....65777......BOLT.........$2900.00........95%......
In advance, much appreciated!
Chris
RULES:
1- INDEX, MATCH items in COL A that are alike. Since, A7, A8 and A9 are alike and grouped together based on their Column A content being the same, then
2 -Using the borders feature, put a border line along the TOP of the FIRST INSTANCE of the duplicate number/text, then place a border line along the BOTTOM of the LAST INSTANCE of the duplicate number/text found...
3 - Draw/border that line out through Column D. (I'd like the ability to define what column to end with if possible) because I may want it to extend to Column E or F in some cases to put notes out to the side of that grouping.
Example shown below. Tried to attach sample test file like previously, but not seeing that capability any more?
"BOM Worksheet"
ROW 4....COL A......COL B........COL C..........COL D.......
ROW 5....12345......ELEMENT....$7500.00........25%......
ROW 6....98473......BOLT.........$2900.00........95%......
_______________________________________________
ROW 7....45877......RING.........$2975.00.........85%......
ROW 8....45877......RING.........$2175.00.........55%......
ROW 9....45877......RING.........$2022.00.........15%......
_______________________________________________
ROW 10....34529......ROD..........$1450.00........65%......
ROW 11....61231......SPACER.....$2900.00........85%......
ROW 12....12348......ELEMENT...$6500.00........25%......
ROW 13....98473......BOLT.........$2900.00........95%......
ROW 14....65777......BOLT.........$2900.00........95%......
In advance, much appreciated!
Chris
