Thank you for all of the suggestions. I tried all three suggestions but only the first one from Debraj Roy worked. The other two macros that look at all worksheets in the workbook did not work and I'm not sure why. It didn't even seem like the macro ran.
Any ideas?
Hi,
I work for a company that owns multiple gas stations. I have a workbook that shows the financials for each station on its own worksheet. If the station does not have any activity within the period being reported, the worksheet is blank. I would like to create a macro that loops through...