SOLVED

Dynamic template in Excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-2560076%22%20slang%3D%22en-US%22%3EDynamic%20template%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2560076%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EBackground%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EI%20have%20a%20gamification%20project%20going%20with%20my%20poker%20stuying%20and%20I%20would%20like%20to%20create%20an%20Excel%20file%20that%20is%20similar%20to%20old%20text-based%20games.%20I%20want%20a%20menu%20and%20a%20character%20panel%20(showing%20progression)%20to%20follow%20me%20on%20every%20sheet%20within%20that%20Excel%20file.%20I%20think%20that%20what%20I%20want%20is%20a%20dynamic%20template(%3F)%20but%20I%20am%20open%20to%20other%20suggestions%20as%20I%20have%20no%20previous%20experience%20with%20Excel%20at%20all.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EQuestions%3C%2FSTRONG%3E%3C%2FP%3E%3CUL%3E%3CLI%3E%3CP%3EIs%20it%20possible%20to%20have%20a%20template%20that%20is%20similar%20in%20every%20work%20sheet%2C%20but%20also%20have%20unique%20information%3F%20In%20the%20picture%20below%20I%20want%201%20(the%20menu)%2C%202%20(the%20header)%2C%203%20(the%20character%20panel)%20and%204%20(the%20empty%20box%20of%20start%20date)%20to%20be%20the%20template%20that%20every%20work%20sheet%20has.%201%2C2%2C%20and%203%20will%20look%20similar%20in%20all%20work%20sheets%2C%20but%204%20will%20have%20a%20text%20and%20pictures%20that%20is%20unique%20to%20that%20work%20sheet.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EIs%20it%20also%20possible%20to%20update%20this%20template%20later%20so%20that%20it%20automatically%20updates%20the%20template%20in%20all%20the%20other%20work%20sheets%3F%20I%20might%20want%20to%20make%20the%20menu%20smaller%20or%20bigger%2C%20add%20more%20pictures%20and%20information%20in%20the%20character%20panel%2Fprogression%20part%20later.%20When%20updating%20the%20template%20will%20it%20erase%20all%20the%20unique%20information%20in%204%3F%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3EIs%20it%20clear%20what%20I%20want%20to%20achieve%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSTRONG%3EAdditional%20information%3CBR%20%2F%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EWindows%2010%3C%2FP%3E%3CP%3EMicrosoft%20365%20App%20for%20enterprise%3C%2FP%3E%3CP%3EVersion%202106%20(14131.20320)%3C%2FP%3E%3CP%3EIncluded%20Excel%20screenshot%20(not%20sure%20if%20I%20should%20include%20the%20actual%20file%3F)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20read%20(%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fusing-a-sheet-as-a-dynamic-master-template-for-other-sheets%2Fm-p%2F79240%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fusing-a-sheet-as-a-dynamic-master-template-for-other-sheets%2Fm-p%2F79240%3C%2FA%3E)%20but%20I%20do%20not%20think%20I%20got%20the%20answer%20I%20wanted%20there.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2560076%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2563701%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20template%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2563701%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1106473%22%20target%3D%22_blank%22%3E%40TarekGG%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20wrote%3A%3CEM%3E%26nbsp%3BIs%20it%20clear%20what%20I%20want%20to%20achieve%3F%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ETo%20which%20I%20must%20reply%20%22No!%22%20Maybe%20it'd%20be%20clear%20to%20someone%20who%20shares%20your%20experience%20with%20%22old%20text-based%20games%22%20but%20it%20isn't%20to%20someone%20who%20doesn't%2C%20at%20least%20not%20this%20someone.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EFurther%2C%20I'd%20say%20that%20you%20probably%20should%20develop%20the%20functionality%20you%20want%20on%20each%20sheet%20before%20you%20fuss%20over%20appearances.%20That%20image%20you%20posted%20looks%20amazing%20(graphically)%2C%20but%20it's%20a%20mistake%20to%20put%20too%20much%20energy%20into%20that%20aspect%20of%20an%20application%20before%20you've%20gotten%20it%20to%20work.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIf%20you've%20got%20a%20working%20sample%2C%20or%20at%20least%20partially%20working%2C%20it%26nbsp%3Bwould%20help%20to%20post%20that%2C%20so%20long%20as%20it%20contains%20no%20proprietary%20info.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2568068%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20template%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2568068%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3BThanks.%20I%20did%20not%20realize%20how%20unclear%20I%20was%20being%20and%20%3CSPAN%3EI%20will%20have%20to%20practice%20being%20more%20precise%20with%20my%20requests%20in%20the%20future.%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3BI%20appreciate%20you%20taking%20your%20time%20to%20respond%20to%20my%20broad%20question.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EHowever%2C%20I%20was%20lucky%20to%20find%20'grouped%20worksheet'%20that%20managed%20to%20satisfy%20my%20needs.%20With%20grouped%20worksheet%20I%20am%20able%20to%20change%20the%20menu%2Fcharacter%20panel%20in%20all%20worksheets%20without%20changing%20other%20things.%20(%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fgroup-worksheets-4e1f7747-3d63-4fd7-8a36-838b05adc0f0%3Ffbclid%3DIwAR2fSw1diR6yFAz3DIBtEx9T-Bg6pm_oeuo6ncVlWRz3sr4fTJidteIPkUg%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fgroup-worksheets-4e1f7747-3d63-4fd7-8a36-838b05adc0f0%3Ffbclid%3DIwAR2fSw1diR6yFAz3DIBtEx9T-Bg6pm_oeuo6ncVlWRz3sr4fTJidteIPkUg%3C%2FA%3E%3CSPAN%3E)%3C%2FSPAN%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Background

I have a gamification project going with my poker stuying and I would like to create an Excel file that is similar to old text-based games. I want a menu and a character panel (showing progression) to follow me on every sheet within that Excel file. I think that what I want is a dynamic template(?) but I am open to other suggestions as I have no previous experience with Excel at all.

 

Questions

  • Is it possible to have a template that is similar in every work sheet, but also have unique information? In the picture below I want 1 (the menu), 2 (the header), 3 (the character panel) and 4 (the empty box of start date) to be the template that every work sheet has. 1,2, and 3 will look similar in all work sheets, but 4 will have a text and pictures that is unique to that work sheet.

  • Is it also possible to update this template later so that it automatically updates the template in all the other work sheets? I might want to make the menu smaller or bigger, add more pictures and information in the character panel/progression part later. When updating the template will it erase all the unique information in 4?

Is it clear what I want to achieve?

Additional information

Windows 10

Microsoft 365 App for enterprise

Version 2106 (14131.20320)

Included Excel screenshot (not sure if I should include the actual file?)

 

I also read (https://techcommunity.microsoft.com/t5/excel/using-a-sheet-as-a-dynamic-master-template-for-other-sh...) but I do not think I got the answer I wanted there.



2 Replies

@TarekGG 

 

You wrote: Is it clear what I want to achieve?

 

To which I must reply "No!" Maybe it'd be clear to someone who shares your experience with "old text-based games" but it isn't to someone who doesn't, at least not this someone.

 

Further, I'd say that you probably should develop the functionality you want on each sheet before you fuss over appearances. That image you posted looks amazing (graphically), but it's a mistake to put too much energy into that aspect of an application before you've gotten it to work.

 

If you've got a working sample, or at least partially working, it would help to post that, so long as it contains no proprietary info.

best response confirmed by TarekGG (New Contributor)
Solution

@mathetes Thanks. I did not realize how unclear I was being and I will have to practice being more precise with my requests in the future. I appreciate you taking your time to respond to my broad question.

However, I was lucky to find 'grouped worksheet' that managed to satisfy my needs. With grouped worksheet I am able to change the menu/character panel in all worksheets without changing other things. (https://support.microsoft.com/en-us/office/group-worksheets-4e1f7747-3d63-4fd7-8a36-838b05adc0f0?fbc...)