Not very good with VBA code here and need some help please. I have two workbooks within the same folder and typically only have one workbook open. I have multiple years of data in the closed workbook. When I am in the open workbook I can call for the data of any year by selecting the year via a drop-down box in a specific cell which is "B1". I need to have the year that shows in the open workbook automatically update the year cell which is "B1" in the closed workbook whenever it is changed in the open work-book. I assume that the code needs to open/update/close the workbook which needs to be updated "behind the scenes".
This works well for me when both files are open but I need to make this work when only one file is open. Can someone help me with a simple code example please?
Tim