Workbook formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1672297%22%20slang%3D%22en-US%22%3EWorkbook%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1672297%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHoping%20some%20one%20can%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20it%20that%20if%20i%20add%20an%20amount%20on%20the%20template%20sheet%20in%20column%20D%20(time)%20it%20needs%20to%20complete%20the%20data%20in%20columns%20E%20through%20to%20S.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20to%20be%20able%20to%20do%20that%20it%20needs%20to%20read%20the%20data%20that%20has%20been%20added%20in%20column%20X-Z%20and%20column%20AA.%3C%2FP%3E%3CP%3EColumn%20AA%20pulls%20through%20the%20data%20from%20Medical%20Aid%20Info%20which%20then%20matches%20up%20to%20the%20same%20headings%20in%20the%20template%20sheet.%20However%20this%20is%20influenced%20by%20the%20information%20from%20sheet%20ICD10.%20If%20ICD10%20is%26nbsp%3B%20specific%20ICD10%20information%20from%20medical%20aid%20sheet%20needs%20to%20be%20completed%20in%20the%20template%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20in%20template%20sheet%20in%20column%20FF%20the%20info%20that%20is%20in%20FF%20info%20sheet%20needs%20to%20pull%20through%20as%20per%20what%20has%20been%20put%20in%2C%20in%20column%20AA%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanking%20everyone%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1674152%22%20slang%3D%22en-US%22%3ERe%3A%20Workbook%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1674152%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20not%20able%20to%20clearly%20understand%20what%20exactly%20need%20to%20be%20done%2C%20request%20you%20to%20fill%20in%20sample%20data%20manually%20in%20couple%20of%20lines%2C%20that%20might%20help%20to%20work%20towards%20solution.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1676745%22%20slang%3D%22en-US%22%3ERe%3A%20Workbook%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1676745%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F794624%22%20target%3D%22_blank%22%3E%40Satishrkl%3C%2FA%3EHope%20this%20helps%20as.%20The%20blank%20cells%20can%20show%20zero%20as%20they%20will%20all%20need%20formulas%20in%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

 

Hoping some one can help.

 

I want it that if i add an amount on the template sheet in column D (time) it needs to complete the data in columns E through to S.

 

But to be able to do that it needs to read the data that has been added in column X-Z and column AA.

Column AA pulls through the data from Medical Aid Info which then matches up to the same headings in the template sheet. However this is influenced by the information from sheet ICD10. If ICD10 is  specific ICD10 information from medical aid sheet needs to be completed in the template sheet.

 

Then in template sheet in column FF the info that is in FF info sheet needs to pull through as per what has been put in, in column AA

 

Thanking everyone in advance.

 

 

 

2 Replies
Highlighted

Hi - not able to clearly understand what exactly need to be done, request you to fill in sample data manually in couple of lines, that might help to work towards solution.

Thanks

 

Regards

 

Highlighted

@SatishrklHope this helps as. The blank cells can show zero as they will all need formulas in them.