Forum Discussion
Help creating database index formula
Hi there, I'm trying to wrap my head around how to go about this one, but I'm stumped. Maybe it isn't possible. I've created an individual file template for each piece of equipment we own. I want a...
Not exactly what i'm trying to do - i only want about 6 cells worth of info in the index, where as the individual file holds many records, pictures etc. I want the index to be updated automatically whenever one of the individual files are changed as well.
thanks for your help Jan
If you can modify the individual files, what would help is insert a sheet with a simple table which lists the values that you need to pull out, using formulas. Then using the solution I mentioned above would work beautifully. Change a file (or add or remove one), open the overview book and press refresh on the data tab.