I have a large workbook of some 50 worksheets. I need to be able to keep them
in a specific order, based on a value in Cell F2.
By necessity I have to alter the order of the sheets, and then have to
return them to their correct order manually (Assuming I have saved changes
whilst moved out of position) . Is there a simple way of either setting a
default sheet order and/or returning the sheets to the specific order, based
on the value in F2 ?
I understand that it can be done in VBA code - but I havn't a clue how to do
this. Any advice would be much appreciated.