Formula required or vba to input data automatically for some columns from huge database

[RAM72]

Hi All

I am looking formula or vba to fill some columns in order to make calculations from these columns .

However in sheet data calculation column A is entered manually depending data recieved in column L,M,N .

In entering the code manually in column A and B for data calculation sheet,a formula or vba will fetch data in sheet codedata taking column A in account from B to I to fill the data calculation sheet column C and J

Note Codedata can have 20000 records

See annexed for explicit details .

Thanks in advance those who can help me .

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[RAM72]

Hi ,

See if this is OK.

Narayan

Hi Narayan

Just download the file , I do not see the formulas.

Could you recheck plse

thanks

 

[NARAYANK991]

Hi ,

I assume you need formulae in the Data Calculation tab ; see the range C17:J17.

Narayan

 

[RAM72]

Hi
Just checked formula is ok on column C but it does not adjust column D to J automatically from codedata sheet.
See annexed
RAM

 

[NARAYANK991]

Hi ,

Please take a second look at the formula that is present in my uploaded file.

It is a multi-cell array formula ; select the entire row range , say C17:J17 , and enter the formula as an array formula , using CTRL SHIFT ENTER.

Your formula is different from mine , which is why the results are different.

Narayan

 

[RAM72]

Hi ,

Please take a second look at the formula that is present in my uploaded file.

It is a multi-cell array formula ; select the entire row range , say C17:J17 , and enter the formula as an array formula , using CTRL SHIFT ENTER.

Your formula is different from mine , which is why the results are different.

Narayan

Hi

Yes, you are right,I tried now it ok.

Thank you for your great help to solve this as this will help me a lot from a painful task to do daily.