Hi,
Encountered a problem today where maybe you guys can advise what to do. Problem goes like this:
I have an Excel sheet packed with projects (every project has a row).
Now I also need another excel file/database where all the projects are listed + some extra columns with descriptions.
The second Excel file should be updated automatically (on open/update) when I change something in the first file but ofcourse the descriptions should still match the projects and should not be changed.
I already tried making an Excel file and using the 'get external data' but then I encountered some problems with the description rows that did not match the projects anymore. That's why I thought of putting the projects in a database instead of creating a second Excel file. But I don't really know how to do this.
Thanks in advance for your help/advise.
Tim
Bookmarks