I have a summary sheet that links to other workbooks. The workbooks it links to changes each week using the edit links function.
Can you obtain a certain string from within the formula, not what's displayed in the cell, of one of the linked cells?
My summary links to a specific folder with a date in the titel. I want to be able to extract that date and show it in a cell.
Hope me that made sense
thanks in advance.