Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good morning,
I have a worksheet with rows of data. Column D identifies the client account number. There are more often more than 1 row of data for the same client account. The worksheet is already sorted so that the the data is sorted into the various different clients, ie: D E F Client # Description Amount LBL001 Coke 100 LBL001 Pepsi 50 LBL002 Coke 75 LBL002 Coke 80 LBL002 Pepsi 100 LBL003 Sprite 30 LBL003 Coke 50 I would like a macro to run that places a "Thich Bottom Border" after each group of like client accounts. Could someone please assist me in a method that checks whether Column D in one row is the same as the Column D in the row below, if so, it checks the next row below that, if not, it places a "thick Bottom Border" to identify that that is the end of one group and start of the next. I would really appreciate the help, thank you Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort rows and move borders with rows | New Users to Excel | |||
Deleting groups of rows when using a macro recording? | Excel Discussion (Misc queries) | |||
Macro to place dated rows in email and send??? | Excel Programming | |||
Adding new rows with borders | Excel Programming | |||
Sum rows in groups | Excel Worksheet Functions |