SOLVED

Excel Multiple Views of Same Spread-sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-3363789%22%20slang%3D%22en-US%22%3EExcel%20Multiple%20Views%20of%20Same%20Spread-sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3363789%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20a%20cash-flow%20spreadsheet%20which%20has%20one%20group%20of%20rows%20which%20show%20expected%20expenditure%20over%20time%20for%20a%20series%20of%20projects%2C%20one%20row%20per%20project.%20Elsewhere%20there%20is%20another%20similar%20group%20of%20rows%20showing%20expected%20income%20from%20those%20projects.%3C%2FP%3E%3CP%3EI%20would%20like%20to%20create%20an%20alternative%20'view'%20where%20the%20expenditure%20row%20and%20the%20income%20row%20for%20each%20project%20are%20adjacent%20to%20each%20other.%20This%20second%20'view'%20could%20be%20a%20'read%20only'%20type%20if%20that%20made%20things%20easier.%3C%2FP%3E%3CP%3EFor%20clarity%2C%20I%20want%20to%20maintain%20both%20'views'%20at%20the%20same%20time%20with%20an%20easy%20switch%20from%20one%20to%20the%20other%20with%20the%20underlying%20.xlsx%20or%20.xlsm%20file%20acting%20as%20a%20common%2C%20shared%20data-base%20for%20the%20two%20'views'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%20please%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20any%20suggestions%20or%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3363789%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3364645%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Multiple%20Views%20of%20Same%20Spread-sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3364645%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1388167%22%20target%3D%22_blank%22%3E%40phillipsrb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20might%20explore%20the%20New%20Window%20feature%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Patrick2788_0-1652359292343.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371145i69A72AFB5A45FB2B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Patrick2788_0-1652359292343.png%22%20alt%3D%22Patrick2788_0-1652359292343.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3365524%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Multiple%20Views%20of%20Same%20Spread-sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3365524%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428790%22%20target%3D%22_blank%22%3E%40Patrick2788%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Thanks%20for%20suggestion.%20I'll%20take%20a%20look.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

I have a cash-flow spreadsheet which has one group of rows which show expected expenditure over time for a series of projects, one row per project. Elsewhere there is another similar group of rows showing expected income from those projects.

I would like to create an alternative 'view' where the expenditure row and the income row for each project are adjacent to each other. This second 'view' could be a 'read only' type if that made things easier.

For clarity, I want to maintain both 'views' at the same time with an easy switch from one to the other with the underlying .xlsx or .xlsm file acting as a common, shared data-base for the two 'views'.

 

Is this possible please? 

 

Thanks in advance for any suggestions or help.

2 Replies

@phillipsrb 

You might explore the New Window feature:

 

Patrick2788_0-1652359292343.png

 

best response confirmed by phillipsrb (New Contributor)
Solution

@Patrick2788 

 

Hi Thanks for suggestion. I'll take a look.