Write Cell in a Excel based on another cell value in the Excel

Hello everyone,

is there a way to write in column I based on column B’s value? So in this case I want to write in “I” a value that I already stored in a variable when Bs value is 03.01.2022? I put the values of column B also in a variable.

For example, if B is 03.01.2022 I want to insert my variable value (e.g. 40 hours) into I2 and do this for every row in my excel sheet.

I hope it will be solution for you:
BlankProcess25 (2).zip (9.1 KB)


HI @Agnetha - are you using studio or studioX?

I use Studio :slight_smile:

I will test it, thanks a lot and get back to you!

I tried it, but now I get the error: If: Conversion from type ‘DBNull’ to type ‘Date’ is not valid.
The StartdatumKW is the variable “myStrDate”.
Dou you know, why it is showing this error?

Could you provide me example of excel file ?

yes, of course!
Example.xlsx (19.8 KB)

I solved the error, now everything is working, thanks a lot! :slight_smile:

1 Like

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