I am trying to make a validation drop-down in another closed workbook.
Right now I have two workbooks,
1st workbook = "DATABASE"
2nd workbook = "REPORT"
I used the "database" to fill some fields in my "report" using the validation drop down list, I have managed to make this when both workbooks are OPEN, but when my "DATABASE" workbook is closed, I can't access the drop-down list anymore.
I want to access the info of my "database" without having the workbook open, and i struggle to find a simple solution to this.
Could anyone guide me in the right direction on how to find a solution?