I added that and added to the macro for the remaining columns. I must be misunderstanding something, it's not quite working, but I'm getting close. :)
Sub FormatWeeklyBadgeReport()
Dim ws As Worksheet
Dim lastRow As Long
Dim i As Long
Dim nameToFind As String
Dim rng As...
I tried to run the macro but had a couple problems.
first I need to be able to run it in my personal macro workbook. So I have to change from this workbook to active workbook.
But then the macro gets hung up on this line
I have a report for work that I need to format a certain way every week, and it takes a couple hours. I am hoping to have help creating a macro to make it quicker. I would need to save the macro into a personal macro workbook or be able to run it in all workbooks.
I have uploaded a copy of the...
