Hi Guys,
Really could do with some help from a few experts on here... firstly i've got to say I've muddled my way to this point so any help offered is greatly appreciated.
I've a sheet (Cover page) with a command button that when clicked, lists all the sheets in the workbook but more importantly as a hyperlink so you can jump to it. That populates Column A.
Each sheet is identical. I could do with returning values from specific cells (say b4, C6) on each sheet onto the Cover page page Column B, Column C etc...
so
Column A has the list of sheets, as they are generated it finds the values from those sheets.
could I use a macro?
Thanks again
Really could do with some help from a few experts on here... firstly i've got to say I've muddled my way to this point so any help offered is greatly appreciated.
I've a sheet (Cover page) with a command button that when clicked, lists all the sheets in the workbook but more importantly as a hyperlink so you can jump to it. That populates Column A.
Each sheet is identical. I could do with returning values from specific cells (say b4, C6) on each sheet onto the Cover page page Column B, Column C etc...
so
Column A has the list of sheets, as they are generated it finds the values from those sheets.
could I use a macro?
Thanks again
