If you are using this on multiple workbooks, would you like to have it
cycle through all workbooks in a particular folder and generate one
report for all of them?

Charles

bpotter wrote:
Thanks so much for that code. I will try that!!! Also in reply to the
second message. I do this on 15 workbooks for 365 days a year. These
each will have about 50 entries in each.