Hi All. This is a situation I need your help with. I do have a makro, that is copying formulas in columns J:L based on data populated in columns A:G.
What I need is change the this VBA, which is running live to VBA that I can use on a Button (I mean, whenever I press that button). Also I am planning to protect formulas, that I am using in columns J:L by copying them to Sheet2, so I neet to modify it that it can run by clicking on button on Sheet1, but formulas gonna be on Sheet2. For myself it is complicated.
Could you please give me a hand with it? Thank you very much
What I need is change the this VBA, which is running live to VBA that I can use on a Button (I mean, whenever I press that button). Also I am planning to protect formulas, that I am using in columns J:L by copying them to Sheet2, so I neet to modify it that it can run by clicking on button on Sheet1, but formulas gonna be on Sheet2. For myself it is complicated.
Could you please give me a hand with it? Thank you very much
Code:
[URL]http://silven.mywi.sk/upload/upload/CopyFormulasByData.xls[/URL]
