Anbuselvam K
Member
Hi
In the attached excel file have 3 worksheets called Permanent Formulas and the Temporary Formulas which are the source data and Master Data which is input data.
In the Sheet Master Data Range A9: B12 is the input data. With this input data, it has to find the appropriate formulas from both formulas sheets and the desired output comes as like the Master data range C9: H12
To achieve these results what kind of code I can write? Can you please suggest and give a start to finish the code by myself.
Thanks in Advance.
Sincerely Yours
Anbuselvam K
In the attached excel file have 3 worksheets called Permanent Formulas and the Temporary Formulas which are the source data and Master Data which is input data.
In the Sheet Master Data Range A9: B12 is the input data. With this input data, it has to find the appropriate formulas from both formulas sheets and the desired output comes as like the Master data range C9: H12
To achieve these results what kind of code I can write? Can you please suggest and give a start to finish the code by myself.
Thanks in Advance.
Sincerely Yours
Anbuselvam K
Attachments

10.6 KB Views: 8