Forum Discussion

NyxSA's avatar
NyxSA
Copper Contributor
Sep 16, 2020

Workbook formulas

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.

 

 

 

  • Satishrkl's avatar
    Satishrkl
    Copper Contributor
    Sep 16, 2020

    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

     

Resources