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

[Agnetha (Agnetha Bellman)]

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.

[pikorpa (Piotr Kołakowski)]

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

[Djh (Dillan Hackett)]

HI @Agnetha - are you using studio or studioX?

[Agnetha (Agnetha Bellman)]

I use Studio

[Agnetha (Agnetha Bellman)]

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

[Agnetha (Agnetha Bellman)]

@pikorpa
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?

[pikorpa (Piotr Kołakowski)]

Hey,
Could you provide me example of excel file ?

[Agnetha (Agnetha Bellman)]

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

[Agnetha (Agnetha Bellman)]

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