May I ask how can I extract data from specific column.
For example, how can I collect first data :
‘from cell AB2:AB5 to cell E2 from ‘’;
from cell AE2:AE5 to cell F2 from;
cell AC2:AC5 to cell E3 from
from cell AD2:AD5 from ‘seed’ to cell E4, etc based on each FA#.
My workflow is like that, but there are some mistake when I edit it, can anyone help me to fix it? Many thanks!
Workflow:
Main MU-bias.xaml (13.9 KB)
Is this what you want?
MU bias WB.xlsx (32.6 KB)
Thank you so much, but if I want to write cell Start Day and End day (Column M and N) as well as Proof batch (Column S) from input file to start day and end day (column B and C) as well as Proof batch (column I) from output file in the merge and merge format.
How I can edit?
Many thanks
Thank you so much. This issue is solved, another problem is that is the output file of column H, the average F is come from the two number of average of column G. For example, H2 is from G2/G3, H4 is come from G4/G5. How can I do the merge and merge of every two cell of column G and then I need to do the set the formula of “G2/G3” and get the 5 d.p.
Thank you so much!
I am writing the robot in this way, but it can’t fulfill my target.
Workflow:
Main MU-bias (cal).xaml (28.7 KB)
@FerdinanAlberto Can you help me in Do calculation in every two cell in merge and merge manner . Thank you so much!!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
