copy,paste,calculate Cell value based on calculations & comparisonsother cells same row. Decimal places

[fixer]

Hi Experts,

I am looking for a macro that will do the the things mentioned below
Macro will be placed in a macro.xlsm
macro.xlsm & 1.xls both are located in different path so the path should be hardcoded in the macro, so i can change it as per my needs


In column K, If after decimal if the second digit is 0 then Move all the data from after decimals to before decimals
K2 has data that has the second number after decimal is 0, so the output would be in K2 10030.00


Thnx For the Help
https://www.excelforum.com/excel-pro...e-decimal.html

[fixer]

Problem Solved

[DocAElstein]

The macro that you obtained from excelforum just multiplies all the column K values by 100. Your description suggests that you did not want just that.

[fixer]

Yes Sir, I got the macros for the same Sir
Thnx Alot Sir for ur Great Help Sir
Have a Awesome Day Sir