Re: Formula to recognise a new sheet being added to a file, then returning a value
Added manually. I could set the spead sheet up with say 500 sheets in the first instance. Then I just need a formula to link the summary to each sheet individually (opposed to linking all 5oo sheets manually). Its easy to sum one cell on each sheet to one total figure on the summary, but I don't know how to list each total from each sheet separately on the summary sheet.
Thanks in advance.