I have come into a dilemma with building a macro for a report. I will receive a large report which varies in size a few times a month. I cannot use the report I work with but I have created a sample to use for this issue and should be able to work the code into my report. Please be aware though, the report is much larger than this both in number of rows and columns.