Input data into specific column cell

How can i input data in column E depend on Date?

For example, today is 7/14, RPA will enter data to E10
Today is 7/15, RPA will enter data to E11

thank you !

Use system.datetime.now to get today’s date and then perform a match in a loop. If it matches update the value.

1 Like

@Edd_0820 Use Lookup Range activity and pass today’s date into Input it will give you a cell address then replace A with E then use this address into write Cell

If data in column A is datatime type, not string data

can i use lookup function?

lookup function seems only search for string data only

thank you !