Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is it possible to have multiple splits in one worksheet?
I am compiling a worksheet that tracks weekly progress on a monthly basis.I
would like to be able to have each week on one page and have a split after each week so that the user can scroll through each week seperately on the same page if that makes any sense.I did try the split option but i need it to just show one particular week per split and not the whole page.I also need to have different data per week and with the split option it links data basically showing the same page in both halfs. |
#2
|
|||
|
|||
Could you do this buy outlining the worksheet? "NHonor" wrote: I am compiling a worksheet that tracks weekly progress on a monthly basis.I would like to be able to have each week on one page and have a split after each week so that the user can scroll through each week seperately on the same page if that makes any sense.I did try the split option but i need it to just show one particular week per split and not the whole page.I also need to have different data per week and with the split option it links data basically showing the same page in both halfs. |
#3
|
|||
|
|||
That works thank you.
"kim" wrote: Could you do this buy outlining the worksheet? "NHonor" wrote: I am compiling a worksheet that tracks weekly progress on a monthly basis.I would like to be able to have each week on one page and have a split after each week so that the user can scroll through each week seperately on the same page if that makes any sense.I did try the split option but i need it to just show one particular week per split and not the whole page.I also need to have different data per week and with the split option it links data basically showing the same page in both halfs. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is it possible to have multiple splits in one worksheet?
What do you mean by "outlining the worksheet?"
"kim" wrote: Could you do this buy outlining the worksheet? "NHonor" wrote: I am compiling a worksheet that tracks weekly progress on a monthly basis.I would like to be able to have each week on one page and have a split after each week so that the user can scroll through each week seperately on the same page if that makes any sense.I did try the split option but i need it to just show one particular week per split and not the whole page.I also need to have different data per week and with the split option it links data basically showing the same page in both halfs. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simultaneously work in a work book with other users | Excel Discussion (Misc queries) | |||
How do I show multiple worksheets on multiple screens? | Excel Discussion (Misc queries) | |||
Why are there multiple instances of same person on shared workshee | Excel Discussion (Misc queries) | |||
There is no way to view multiple sheets from one workbook | Excel Discussion (Misc queries) | |||
Count rows based on multiple criteria | Excel Worksheet Functions |