I am trying to get a summary sheet in Excel 2007 to update dynamically from each worksheet in the workbook.
The Summary page contains the sheet name.
The individual sheets all have a range of values (derived from formulas) which need to be updated on the summary page in the row that the sheet name is in.
Can you help with this?
These are large test plans and it is very tedious to have to go in and add something like the following to each cell which needs updated.