Feb 07 2022 09:50 AM
Feb 07 2022 11:02 AM
If the sheet is in another workbook that is open in Excel, you can use the INDIRECT function:
=INDIRECT("'Sample Data.xlsx]"&TEXT(TODAY(),"dd.mm.yyyy")&"'!E2")
Feb 07 2022 11:14 AM
Feb 07 2022 11:48 AM
Alas, INDIRECT does not work with closed workbooks. There is no good solution for that.
Feb 07 2022 11:51 AM
Feb 07 2022 12:14 PM
Either keep both open, or move the sheets from both into a single workbook.
Feb 07 2022 12:46 PM
Feb 07 2022 01:03 PM