I'm having a hard time coding this one.
My objective is to select the sheet name based on a cell value from another work book.
Say, in workbook1, range(a1)= d-4
Then i want sheet(d-4) opened in workbook2.
The catch is, i want to dynamically do it.
That is, once sheet(d-4)...