I need to create an Excel template that prints some standard metadata in the
footer of each worksheet. The metadata consists of Document Name, Author,
Last Save Date, and Status. (Status is a one-word entry.) To populate the
footer, I would like to have a separate worksheet (named €œMetadata€�) where
the user would fill in the values for these four fields, then these values
would automatically propagate to the footers of the other worksheets in the
workbook. Id like the footers to appear as follows:

Document Name: <name
Author: <name
Last Saved: <date
Status: <value

I expect Ill need to use VB scripting to make this work. Can anyone point
me to a source where I can get some guidance on doing the above task? Im
not deeply versed in VB myself but Im willing to try it. Thanks for any
help.