Hi all
I have seen a number of solutions that address variations of my requirement,
but can't find one that deals with it precisely or that I can adapt with my
limited knowledge.
I have a folder that contains about 100 workbooks. Each workbook contains a
sheet for each month, with the latest sheet being called "JUL 06". There are
no other files in this folder.
I have a separate workbook (which can be in any location from my POV) which
contains only one worksheet, named "AUG 06". This is to be used as a template
for a new sheet in the 100 books. So what I want to do is copy the sheet "AUG
06" and insert it as the last sheet in each workbook (and, since the 100
workbooks contain links, suppress the update links dialogue).
I will repeat this each month, so would be nifty if we can include a request
to specify the name of the sheet to be copied. Alternatively, maybe I should
specify the name of the new worksheet as it is created in each book, so I
don't need to maintain the template.
As always, your expert help is eagerly anticipated and gratefully received.