Compare columns & based on that increase or decrease the column Data by Percentage

[MoldyBread]

If column D is lower then column H then calculate 1% of column D & add it to column D & If column D is greater than column H then calculate 1% of column D & subtract it to column D
After runing the macro, the data pasted in column M is the output of the macro in column D, Column M data is only for understanding purpose
I will run the macro from a different file located in a different path , file name is vbamacro.xlsm

[nankw83]

Hey MoldyBread,

Below code should work on your sample file. However, I am not sure what exactly you want. You would place the code & run it from a file to execute the code in another file called "vbamacro.xlsm" ? If yes, uncomment the commented line of code below & try … Just be aware that there's a save action to the other file

Please Login or Register  to view this content.

[MoldyBread]

It's working Awesome
Thnx Alot Nankw83

[nankw83]

Glad to help & thanks for reporting back. If the suggested solution takes care of your request, please mark this thread as 'SOLVED' using Thread Tools from the top menu & consider giving reputations to those who have helped by clicking the star under their usernames