Dynamic sheet automation with multiple formula based on cell reference

[achu]

Hi All,

I am looking automate sheet where automatically formula cate based on vlookup.

for examples


Sheet name - Formula list
Key formula
A12 A2-C2 * Sum(K2+L2)
A22 sum(A2:C2)/N2
A223 sum(A2:C2)/N2 +sum(A2:C2)*1.88
etc


main sheet - data

in the data sheet based on key auto capture formula , and extract from formula sheet directly

i have 200 formula so each formula is not possible to manually enter in main sheet , so need to automatically captured formula refering the formula sheet

Thank you

 

[vletm]

A sample Excel-file, which shows Your case, would help others to see - what is going on? what do You really need?