Hello All,
I am try to do some coding to open to a certain tab in a different workbook.
I am creating the sheet tab name that I need to open with concatenate (the
name has three parts to it based on what the user select). The cell has a
name (sheettab1but the value in the cell will change). Is it possible to use
the value in sheettab1 to open to a certain tab in a different workbook?
Thanks