Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting grouped rows | Excel Discussion (Misc queries) | |||
Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
Copy Hyperlinks to other cells | Excel Programming | |||
Maintaining in-doc hyperlinks when rows/cells change | Excel Discussion (Misc queries) | |||
How to search for grouped rows? | Excel Worksheet Functions |