Hi
Have a list of tabs in a column on Sheet1. Say 10 sheets.
There is a Macro working on Sheet1, and I may wish to go to Sheet7 and enter data cut or paste. After that in the loop, the next entry maybe required on Sheet1, then maybe Sheet9, etc
The macro runs on a loop thru multiple entries until loop finished. This requires cut from 1 sheet and paste to another sheet, multiple times.
What I would like to establish which is the easiest way (macro or script/function) to select the sheet required and enter data.
Tabs are dynamic in that more are created often. The list of tabs on Sheet1 is updated automatically.
Question: (at last) Is there a way that in the macro when a Sheet is selected in Sheet1,the required sheet opens? One option is when the Tab list is placed in Sheet1 it automatically makes all entries as ‘hyperlink’ in all cells . And it would refresh each time the ‘tab’ listing macro is run. Would I need to put a function in the cell to help do this?
Summary: Easiest way to setup to go to another sheet via macro. It is just the Hyperlink bit that I am not sure about.
Thankyou
Charles Harris