How to copy workbook and formulas to read to the present month

[Ali]

Hi
Hope some-one can assist. I have a workbook for stock control of various
items PER MONTH. It consists of a 3 worksheets (stock control, costings and
summary) and is named per month, example SEPTEMBER. Costings and summary
read from the stock control worksheet..
If I re-save the entire WORKBOOK for a new month, and call it October, the
costings and summary sheets still read values from Sep!
Is there any way i can save it each month and up-date the values to read
from the present month Stock Control worksheet. In particular can i do this
without a Macro as I am pretty useless with Macros.
Thanks in advance

 

[YESHWANT]

Hi Ali,

you re-save the entire WORKBOOK for a new month, and call it October and
before closing the same, click on edit - links and re-assign the path of the
current file and
you are at home.

 

[Ali]

Hi there
Thats great it does work fine for me. Sadly I am leaving the Excel
documents in the hands of a staff member who will only manage to re-save for
a new month and enter data in a few cells I have left without password
protection. They will not manage to ensure they change the source so i was
hoping there was a way to do this automatcally. Thanks anyway