Just another thing among many that the macro recorder has taught me. <gr

--
Charles Chickering

"Better to remain silent and be thought a fool then to speak out and remove
all doubt." - Abraham Lincoln


"JLGWhiz" wrote:

Well CC, I learned something. I never knew a direct insert could be made
from a copy. I have always inserted the row and then did a copy + paste or
copy to. Now I know.

"Die_Another_Day" wrote:

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.