Hi,
I am hoping someone can me. I need a macro/code that will select a sheet in book2.xls, based on what is input into book1.xls sheet1 cell B38. The value of cell B38 is a date (e.g. 3/31). The worksheet names in book2 are dates.
So for example: book1 sheet1 cell B38 contains "3/31". I would like a macro that will open book2 find the sheet named 3/31 and select that worksheet.
Thanks very much!
I am hoping someone can me. I need a macro/code that will select a sheet in book2.xls, based on what is input into book1.xls sheet1 cell B38. The value of cell B38 is a date (e.g. 3/31). The worksheet names in book2 are dates.
So for example: book1 sheet1 cell B38 contains "3/31". I would like a macro that will open book2 find the sheet named 3/31 and select that worksheet.
Thanks very much!