Check Cells + Confirm Today's Date

Help Studio
1
  • Validation or condition
    • Starting from Row 16
    • Process stops when data in Column A is blank
    • Check if data is available in row O
      • If blank, go to next row
      • If date, Copy/Store data from Column E
2

Capture
Capture1244×204 50.5 KB

This is the Excel sheet I’m working on. However I’m stuck on this progress

3

@kristianne.magro

Welcome to forums

Check as below for your reference

Hope this helps you

Follow Link

Thanks

4

Thank you for your reply. I just need to just if the cell A is empty or not don’t need to fill it. Then need to the next Col O and check the same if both are filled and date match in Col O then I need to copy the information from Col E and it continues until the Robot finds a cell from col A empty.

5

The Robot should start from Col A 16

Check Col A if is null - break if not cont to Col O
Check Col O if is null - break if not cont Col E
Check Col E if is null - break if not copy batch number in an array list – if it’s the same number we skip the row