This may be pretty basic but I haven’t had success yet.
I have a block of data within a range on workbook 1.
Each cell has a value that corresponds to tab names of workbook 2.
How can I use these cell’s value to activate the proper corresponding tab on workbook 2?
The code is on another computer sorry no examples right now.
I tried so far setting a variable equal to the cell’s value, but can’t seem to translate it into a workbook object for calling the tabs.