I have twelve workbooks with twelve sheets each. At the end of each month I
need to carry the figures from the formulas on each sheet to the
corresponding worksheet in the new workbook for the next month. Is it
possible to do this with a macro; do macros move from one workbook to
another. Any help would be greatl;y appreciated.