Hi everyone!
I've been wondering if there is a way to bring the information from some fields from other files, but with the names of thise files being on a cell list on your first file.
Let's say that I have a standard template where you can list your business drivers: expense, revenue, costs, etc. and I want to bring that information into a consolidated table in a dashboard. Also there are a lot of files so it's not time efficient to open each and copy it, but I have the route and the exact name of each.
Is there a way so I can save up some time? Maybe have the list aside the table, and reference each value (because I know where the data in which tab and the file name is) from our list
I've been wondering if there is a way to bring the information from some fields from other files, but with the names of thise files being on a cell list on your first file.
Let's say that I have a standard template where you can list your business drivers: expense, revenue, costs, etc. and I want to bring that information into a consolidated table in a dashboard. Also there are a lot of files so it's not time efficient to open each and copy it, but I have the route and the exact name of each.
Is there a way so I can save up some time? Maybe have the list aside the table, and reference each value (because I know where the data in which tab and the file name is) from our list