Get and write into specific column

Hello.
I’m trying to get the last empty column (in this Excel Sheet column CV) and I want to write the data into that column where it’s empty, except the number in row 4 (column BZ). The problem is that it’s not always column BZ so I don’t have a fix one.

@mcLauge,

You want to convert the number to the column value in the excel?

No, I want to sum up each row and write the result in the next column, which isn’t full with data. This means I want to write the result into column BZ. But there are different sheets and the column for the result isn’t always the same.
Do you think it will work if I make an if condition? And what should be in the if condition :slight_smile::roll_eyes: ?

Can you explain a bit? It’s a bit confusing :slight_smile: