Yes I know it's better to upload a sample workbook but
I have 2 workbooks 1 for data (named Data) 1 for input (named input)
The sheet in input are named (example) Nov - Dec 2022
(that is 1 sheet for every period)
In "data" in Cell B1 is the name of the period (example Nov - Dec 2022)
Now I want to combine the LINK to input and the Cell B1 (in DATA) to make a link to the correct sheet and cell in INPUT
For example
Please Login or Register to view this content.
Tia
Bookmarks