Copy cells with hyperlinks and grouped rows.
Hi,
New user to Excel 2011 (Mac), I am trying to create a "navigation system" for my Excel workbook.
I want any of the sheets of my workbook to have cells referencing all the sheets of my workbook. So that, when I click on one of the cell with the reference to the "Sheet X", I go to the "Sheet X".
On the first sheet of my workbook, I have a list of 29 cells (= 1 column of 29 rows) referencing to the 29 sheets of my workbook.
I want to copy this column of 29 rows to each sheet of my workbook.
The problem is I have I also grouped rows in any of these sheets.
On the second sheet of my workbook, rows 3 to 11 are grouped together and rows 13 and 14 are grouped together.
I want to paste my 29 rows in column AR starting in the cell AR2.
How do I copy my 1 column of 29 rows to the visible rows only? Is it even possible?
Thank you.
|