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?
@meitata, the example I shared seems to work can you share another example where the calc sheet includes data for no 2 and no3?
Is this what your calc sheet looks like with other calculations?
I am having a bit of trouble understanding are you trying to generate the calc sheet as an output or A, B, C, and D column in the All sheet tab?
Thanks!
@meitata You are trying to create multiple sheets that is in same fashion of your "Calc" sheet?
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
@meitata, give this a try if it works for you.
Thanks! @grazitti_sapna
is it work for others row?
@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?
Is it possible if I calculate column A B C D with the data on row 2 and 3 in sheet All? @grazitti_sapna
This all values of sheet A B C D @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?
It works just for the first row, and the calculation not work for other row, is it possible to built a macro with calculation on Calcu sheet?
The first row will be the input and the macro will calculated and get the output of first row, and the second row will be the next input and the macro will calculated it and get the output for second row,...., till all row calculate and the output will contain A B C D column of all rows. @grazitti_sapna
