I am not sure you are reading and understanding the posts by Paul Hossler and Artik. Both people have indicated that you have provided too little information for them to be able to build a specific vba solution. Artik has gone to great lengths to how your individual requests "could" be written, but again because you didn't supply enough information its hard to tailor a specific solution.

Before you next reply, have a think about the following information needs;

Since you have a formula in cell C2, what do you want done with it? Your suggestion to "Drag it" is fine but where do you want to drag the formula to? What governs how far to "drag" the formula and in what direction?

The formula as you stated "Formula- calculate 1.5% of column B multiply the result with 56 and paste the result in column D", doesn't mean much as it currently stands. Do you mean that you would like to Multiply the value of B2 by 1.5%, then multiply that result by 56 and then post the result in D2?