Is there anyway that I can update a summary sheet (different workbook) from the data held in another workbook? The problem that I have is that the workbook that contains the data is always updated on a new sheet tab.
Basically, a new sheet is added every week to the file Farm Status and the data is entered. Also every week, I want to print of or email the 3 summary sheets that are held in the file Summary. But I need it to update with the data that is relevant for the new week, ie the new sheet tab. Currently, there is a cell link in there which I have to update every week so that it looks for the correct sheet.
Are there any options that are available so that this the update of the data can be done automatically? An alternative formula, a macro??
I haven't got a clue how to handle this, so any advice would be great.
Thanks in advance.
Basically, a new sheet is added every week to the file Farm Status and the data is entered. Also every week, I want to print of or email the 3 summary sheets that are held in the file Summary. But I need it to update with the data that is relevant for the new week, ie the new sheet tab. Currently, there is a cell link in there which I have to update every week so that it looks for the correct sheet.
Are there any options that are available so that this the update of the data can be done automatically? An alternative formula, a macro??
I haven't got a clue how to handle this, so any advice would be great.
Thanks in advance.
Last edited:
