Forum Discussion
Same table, different and dynamic workbook names
Hello, Long time lurker, first time poster (I think!) I'm looking for a no code option, in the first instance. I have PA in my arsenal but am hoping not to have a solution outside Excel. My compa...
not sure what you mean by 'hyperlink' but I think you are looking for INDIRECT() which will take a text representation of a reference and apply it as a reference but that said I don't think that will work for unopened workbooks and such. I would go with Power Query and in the power query create a dynamic filename reference and just refresh that power query
as for G3 maybe try =TEXT(TODAY()-4,"DDMMYY")
as for G3 maybe try =TEXT(TODAY()-4,"DDMMYY")
