Is it possible to automate a formula across new sheets
In order to feed information into a dashboard, I am importing an excel sheet on a regular basis.
Is there a way to have a formula automatically generate into each newly imported sheet, so that specific information is pulled into a metrics sheet?
The formula would need to pull from the new sheet each time, but from the same row.
Help Article Resources
Check out the Formula Handbook template!