Macro | Create border under certain rows

[Thanks4helping]

Hello,

If you guys could help me with this, that would be great. I've been able to create a macro that completed about 75% of the formatting, but there's a few other items I need formatted to make it work perfectly.

1. If you take a look at column B, you'll see "Name1, Name2, etc" and I need to enter VBA coding so that anytime a name is found it will create a underline border from column A to column W. This is difficult for me because I don't know how to make the macros smart enough to know which rows to underline. The data can always be different so it can't be set to a range of cells.

2. move each of the fields (name 1, name 2, etc..) in column B (category1) and paste to column C (category2) and then delete category 1 column.

3. highlight row with a field (Status3) in column C to where the entire row is highlighted yellow.

4. I know which formula to enter into C4:E10 which is basically going to sum a column based on status in category 2. The problem is, how do I make the macro smart enough to know what row number to end at. For instance, if you enter =sum(E14:??)... what if the first data set goes to 150, then the next is 450, what do you enter in VBA to where it can determine the end of the table?

THANK YOU SO MUCH!!!!!

Macro - create borders formulas.xlsx

[dflak]

I recorded a macro to put a bottom border on a cell and included it in this code.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Not sure about your Sum question what exactly do you want too Sum? The entire Column E?

[Thanks4helping]

Thank you both so much! Dflank that worked absolutely perfectly! What programming could you use for highlighting a row yellow based on a certain status?

[dflak]

Thank you both so much! Dflank that worked absolutely perfectly! What programming could you use for highlighting a row yellow based on a certain status?

Look up Conditional Formatting. There are several ways to apply conditional formatting. My suggestion is to highlight the range to which you want to apply the formatting first and then apply the formatting. It just seems easier for me to do it that way.

There are also about a half dozen different formats you can apply. Some of them apply to the range - applying color gradients, stop lights and other icons based on the cell's relative value within the range. Some apply to a cell based on its own "merit" - these are either "where cell contains" or "use a formula" in nature.

If you are using a formula pay particular attention to absolute and relative referencing of the cells used in the formula.