Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouping Work Sheets
Hate to harp on about Lotus123, however it was possible to group
worksheets together so they stayed together unless using a command in the tool bar. This meant when you formated the first sheet all the others would be the same, plus most important was that if you went to say cc200 on one sheet the others would do the same. The advantage was that we could look at sales data from previous weeks and easily compare with the current week (simple and quick). Joining excel worksheets together with control click does not help. Does anyone know a way to achieve this in excel? Thanks Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouping Work Sheets
I feel your pain.
if you went to say cc200 on one sheet the others would do the same. Excel behaves the same way, almost. It selects the same range on all grouped sheets but it does not scroll the sheets together. So, when you switch to another grouped sheet, you have make the selection scroll into view. Pressing Ctrl-Backspace is a good way. You could put this macro in the ThisWorkbook module to effect this automatically: Private Sub Workbook_SheetActivate(ByVal Sh As Object) ActiveCell.Activate End Sub -- Jim wrote in message ps.com... | Hate to harp on about Lotus123, however it was possible to group | worksheets together so they stayed together unless using a command in | the tool bar. This meant when you formated the first sheet all the | others would be the same, plus most important was that if you went to | say cc200 on one sheet the others would do the same. The advantage was | that we could look at sales data from previous weeks and easily compare | with the current week (simple and quick). | | Joining excel worksheets together with control click does not help. | | Does anyone know a way to achieve this in excel? | | Thanks | Jim | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping sheets copies Header across to all sheets | Excel Worksheet Functions | |||
Grouping Data to New Work Book | Excel Discussion (Misc queries) | |||
Grouping Sheets | Excel Discussion (Misc queries) | |||
How to protect sheet but allow grouping to work | Excel Worksheet Functions | |||
grouping sheets | Excel Programming |