Macro query

Question

hi Everyone,

I have an excel file with hunders of data columns, lets name the first is Data 1. Each column has a duplicate column next to it as Data 1 (new) where I am expecting to receive data input by other peers.

I want to apply the logic for all columns that if !IsNull(Data 1 (new)) THEN Data 1 (new) , else Data 1. How can I create a macro that I could apply to all columns? And just to select in advance to which columns i need to apply the above logic?

thanks a lot!

MateK

atcodedog05 · Answer

Hi @EtamSoko

If you check in the above output Data1 is following if !Isnull([column name new]) THEN [column name new] else [column name] endif

i.e is Data 2 is not null is written to Data 1, if Data 3 is not null is written to Data 1.

So basically if the latest column value is not null it will overwrite on the previous value.

If you tell me where exactly its falling out i can help you out.

EtamSoko · Answer

thanks for it, but still not the solution i need. I will try it once again:

Data 1 Data 1 new

A          B

B          Null

C          Null

Expected Result:

Data 1 Data 1 new

B          B

B          Null

C          Null

The logic would need to be applied to 100 columns which is if !Isnull([column name new]) THEN [column name new] else [column name] endif

this logic should be packed up in a macro and I will want to select pair of fields which will go into the macro and applying the above logic. instead of creating 100 formulas in formula tool with the logic that I have just explained

hope this helps!

thanks

M

atcodedog05 · Answer

Hi @EtamSoko ,

I was able to achieve your requirement. It always takes the last column which is not NULL

Input:

Output:

Workflow:

Select the columns here in yellow highlighted region. In the orange tool.

Hope this near to your requirement. Please check and let me know.

refer.yxmd