Forum

Deeep Deeep thanks again Sunny.

Sorry, Sunny but can you help explain the meaning and logic for this formula used.

Thanks Sunny, the formula is sufficient.

Can we use Sumif command in the macro?

Pls show by an Example ..

Mynda, Is there a way to merge Excel Tables [ Fields column position different ] but using Power query to pick these desired fields from the Table...

Thanks millions Mynda! Will try on that based on above steps suggested, also will consider to join the Course soon to learn the power query skills...

Thanks Mynda. Can you show me the steps how to use the power query to merge ELE_Sheet-A and TAK_Sheet-A files into Main.xlsx base on the mapping ...

Sorry forgot attach

Thanks Sunny, your clever tricks in the macro to set the Header as a tool to compelte the VB loop a lot easier. It exactly fits the purpose. Thanks...

file attached

Thanks Sunny [ Suny] I think you do give a very clear explanation of the VB code to everyone. Now even layman can get an insight and understanding ...