Hi,
I have a number of excel files containing 6-10 worksheets each Every month I need to change the header and footer with new dates before I insert some data. I need a macro which will take the contents of three cells and copy this into the headers and footers.
Note: the dates change every month.
I have tried using a macro recorded on a separate file but it only allows me one set of dates which I cannot change.
Any help much appreciated.
Thanks
I have a number of excel files containing 6-10 worksheets each Every month I need to change the header and footer with new dates before I insert some data. I need a macro which will take the contents of three cells and copy this into the headers and footers.
Note: the dates change every month.
I have tried using a macro recorded on a separate file but it only allows me one set of dates which I cannot change.
Any help much appreciated.
Thanks