Data Compilation

%3CLINGO-SUB%20id%3D%22lingo-sub-2534107%22%20slang%3D%22en-US%22%3EData%20Compilation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2534107%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys!%3C%2FP%3E%3CP%3ESo%20I%20wanted%20to%20create%20a%20dynamic%20data%20compilation%20structure.%20I%20have%20multiple%20sheets%20in%20the%20book%20and%20each%20sheet%20contains%20data%20of%201%20month.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20make%20a%20compiled%20sheet%20of%20that%20contains%20a%20single%20cell%20that%20is%20common%20across%20all%20these%20sheets%20i.e%2C%20I%20want%20a%20compiled%20list%20of%20Portfolio%20Loss%20for%20each%20month.%20%3CSTRONG%3EI%20want%20to%20do%20it%20in%20a%20manner%20that%20if%20the%20user%20creates%20a%20new%20sheet%20and%20adds%20the%20data%20of%20another%20new%20month%2C%20the%20Portfolio%20Loss%20of%20the%20same%20too%20is%20added%20in%20the%20master%20compiled%20sheet.%26nbsp%3B%26nbsp%3B%3C%2FSTRONG%3EI%20would%20love%20your%20help%20in%20the%20same.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2534107%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2625635%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Compilation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2625635%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F661704%22%20target%3D%22_blank%22%3E%40AdityaMahajan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20complex%20solutions%20we%20require%20a%20sample%20File%20version%20of%20the%20scenario.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hey guys!

So I wanted to create a dynamic data compilation structure. I have multiple sheets in the book and each sheet contains data of 1 month.

 

I want to make a compiled sheet of that contains a single cell that is common across all these sheets i.e, I want a compiled list of Portfolio Loss for each month. I want to do it in a manner that if the user creates a new sheet and adds the data of another new month, the Portfolio Loss of the same too is added in the master compiled sheet.  I would love your help in the same.

1 Reply

@AdityaMahajan 

 

For complex solutions we require a sample File version of the scenario.

 

Cheers