Search results

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...