Thank you for the response. That is a great idea and something I have considered
but am still hoping to wrap my brain around using loops. I am currently working
on automating our month end reporting process. This consists of several
departments each with multiple users pulling different figures and reports from
our database, exporting to excel, cleaning up and updating multiple spreadsheets
in multiple workbooks with charts that pull trended data etc. All of these
workbooks are in the same format (oldest to newest). I am hoping to avoid having
to change the format and graphs on all of the worksheets in all workbooks for
all departments and then convince everyone to get use to the new format... I was
hoping I could work around with the one loop... I appreciate your feedback and
you are so very right! I often tend to make things much more complicated than
they need to be .