Hi guys, thank you very much for your tips so far.
I have a big question for me at the moment.
So I have 2 excel files, and I want to connect drop menu from the first one to another one. So when I change something in the first worksheet (then automatically change on another). I did the same with normal cells like =SUM('[File1.xlsx]Sheet1'!A2) but it's only normal cells, and on drop menu, this formula doesn't work.
Please help
Thanks
Bookmarks