I would like to have a summary workbook which calculates totals from several files in the same directory.
Ive got this working fine but what i would like is if a new workbook is added to the directory the summary workbook would add this workbook to its calculations.
all the workbooks will have the same format.
perhaps there is a much better way of doing this.
thanks
greg
Ive got this working fine but what i would like is if a new workbook is added to the directory the summary workbook would add this workbook to its calculations.
all the workbooks will have the same format.
perhaps there is a much better way of doing this.
thanks
greg