How to automate a repeat copy and past action in the excel file

jerry88599

New Member
hello all, I am new to uipath but as what I saw from the introduction I feel this is very powerful tool which could make our life more easier.
hence here comes my first RPA program but basically I still not worked out it yet, therefore I am here to looking for some help from you.
the repeat action will be, I need to fill out all the blank cells with the first cell which contains the content and basically what manually do is I double click the cell in the lower right corner and fill it up till to the next cell which contains something, then I will back to change the properties to copy to avoid any formulas to be filled in.
my logic in realize this robot is:
1. check the first cell of the row, if it contains something
2. if the logic is true, then start to count how many rows was empty down there
3. copy the content of the cell and fill it up(with the formula)
4. check the next row again, if contains something, then repeat.

in the attachment I upload the file for your reference,I just want to fill the AS,EU correspondently.

thanks
 

Attachments

  • Screen Shot 2020-10-18 at 6.26.08 PM.png
    Screen Shot 2020-10-18 at 6.26.08 PM.png
    50.6 KB · Views: 4
Top