How to use 5 sheets in a master sheet?

nkarlsvik

New Member
Joined
Jul 8, 2009
Messages
18
I wonder if there is a way to put entire sheets(with scrolling function) into another sheet?

I have 5 sheets, each showing data of the wereabouts of one particular ship from the entire year, based on week nr.

I want a master sheet that has 5 `windows`, the windows beeing the other sheets in the workbook. I want to be able to scroll these windows to see the entire year, but without having to open up each of the 5 sheets showing the full data.

really need help.

/Nic
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

JimM

Well-known Member
Joined
Nov 11, 2003
Messages
682
Try

Window > New Window (repeat 4 times)

Window > arrange > tick the Tiled and Windows of active workbook options

You can then click in each window and select the appropriate tab

HTH

Jim
 

nkarlsvik

New Member
Joined
Jul 8, 2009
Messages
18
Yes, altough this might be a temporary solution, it is definitly not ideal.
What im looking for is a feature in excel that alows me to merge sheets into another.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,533
Messages
5,529,401
Members
409,871
Latest member
i1patrick
Top