Hello. I pull a report daily with co workers names and performance day seperated with headers. When the report exports to excel it has the same errors every day. So every day I spend half an hour correcting the formating of the report. I've tried recording a macro to make the formatting changes since they are always the same but we have different employees there each day - sometimes there are 15 sometimes there are 25 so the reports are variable in length. There are specific identifiers before and after each of the teams in the report that I run. I'd appreciate greatly some suggestions on how to create a macro that will work to make the formatting changes regardless of how many people are listed on the report. Spreadhseet sample attached. The comments give more detail, the red font notes lines that need to be moved, the green font notes lines that have to be deleted after the data is lined up with the names. I'll seriously appreciate any insight anyone has! Thanks!
Bookmarks