Macro or Multi Row Formula

[meitata]

I need some help for my calcu

I thought I can use Macro for input from and make output to All sheet. But I don't have idea how to do it one by one (per row). And is that true that I can do the calcu sheet with multi row formula?

[Qiu]

@meitata 
You are trying to create multiple sheets that is in same fashion of your "Calc" sheet?

[meitata]

I usually calculated it with excel's macro with that 2 sheets only.... I'll try to fill A B C D columns with calculation from Calcu sheet

[grazitti_sapna]

@meitata, give this a try if it works for you.

Thanks!

[meitata]

Thanks! @grazitti_sapna 

is it work for others row? 

[grazitti_sapna]

@meitata, can you provide a calc sheet containing values for A, B, C, and D related to other rows as well so that I can test it?

Thanks!

[grazitti_sapna]

@meitata, I have replicated your calc for row no 2 and 3 and updated the workflow. Try this!

Thanks!

[meitata]

Is it possible if I calculate column A B C D with the data on row 2 and 3 in sheet All? @grazitti_sapna 

[meitata]

This all values of sheet A B C D @grazitti_sapna 

[grazitti_sapna]

@meitata, I thought you are picking the values of A, B, C, and D from the Calc sheet. so that is why I asked to you enter the values of A , B, C, and D as per the format that you are currently using in the Calc sheet. Could you please try my workflow on your original dataset and let us know if it works for you?

Thanks!