How can I continue from the last row in excel

Help Activities
, ,
1

First of all, I apologize for my bad English.

The numbers in column “A” are averaged and printed in column “C1”, but I want the average to be printed on the next row every time I run the program, what should I do?

here is my program
BlankProcess5.zip (522.8 KB)

1
1566×611 8.33 KB

3

You can use a for each row to see if the cell you need is empty, for example you can use IF row(2).tostring = string.empty, write in your average but if it is not empty, move on to the next row

E.g.

If row(2).tostring = string.empty → write cell
else
move to next row

1 Like
4

Can you show it on the diagram? I am new to the program, I could not fully understand.

5

@lrtetala Pls help :smiling_face_with_tear: :smiling_face_with_tear:

6

If you want to update the Average on “C2”, on ‘Write Cell Workbook - Avg’ activity, Change the C1 to C2.

1 Like
7

No you misunderstand. every time I run it it should automatically write to the next line. I found the solution and I will share it soon.

thanks for the help.

8

Solution:

2
2562×691 24.2 KB

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.