Hi,
Im trying to create a template which, as soon as it is opened, gets saved [probably with auto_open macro] as mmm dd, in a specified folder.
Second part of this problem is, data from these saved sheets is collated in a workbook. Now the links in the workbook have to be dynamic so as to be able to link to sheets only if they are present.
For example, I open template on Feb 2, 4, 5 and 7. However the workbook where I have created links, will expect to see Feb 2, 3, 4, 5, 6 and 7 and will probably give me a REF/# because of the missing sheets.
Any advise?
Im trying to create a template which, as soon as it is opened, gets saved [probably with auto_open macro] as mmm dd, in a specified folder.
Second part of this problem is, data from these saved sheets is collated in a workbook. Now the links in the workbook have to be dynamic so as to be able to link to sheets only if they are present.
For example, I open template on Feb 2, 4, 5 and 7. However the workbook where I have created links, will expect to see Feb 2, 3, 4, 5, 6 and 7 and will probably give me a REF/# because of the missing sheets.
Any advise?