Formatting Help

[tburch98]

Hi I am working on a file that is filled from an Access database. The excel file has multiple tabs with a simple format with a "header", "data" and a "total" line. When the files are updated the formatting tends to get messed up. The data section changes based on the number of cases pulled in from Access. Is there a macro that will keep specific formatting for the data section and a separate formatting for the total line?

 

[Gerald Higgins]

There are ways of doing this.

For the header, if your header is always in row 1, and row 1 only, then it's simple to write code that will format row 1 the way you want it.
If you're not sure how to do this, try using the macro recorder while you actually apply the format you want to row 1.
That should give you usable code.

For the total line, you need to find some way of identifying which line is the total.
For example, it might be the row that contains the word "TOTAL" in a specific column.
OR, you might be able to count the number of occupied rows, and use that to determine the position of the total row.
Once you've done that, you can then apply the "total" format to the line that you have identified as the total.