Copy formula from left and right column of user selected

Hi

Please help me to create VBA Code

Column F I am having "SUM" Formula, the same row on other columns the numbers are in paste special. I want to copy column F formula to left cells and right cells on

Column F I am given as example this may be in G or H also, but entire column the formula should be in same column only

selection of column where its having formula is required by user input. ( User to type column name ex "C")

left and right columns also required as user input ( User to type C:E) for Left and Right(G:K) whatever they input the formula to be copied.
Sample Formula copy.PNG

Hi Thanks for the code

The user also has to tell the code to what direction the code has to paste the copied formula.
In this code case, type left (if the paste range is to the left), type right (if the paste range is to the right).

Here need change, both left columns and right columns required by input box, like instead of type left ,user to provide coulmn reference example C:E and G:K
Because A:B I have some text that should not be disturbed. Similarly on right colum L I have some text.
That's why I mentioned in request list as below

left and right columns also required as user input ( User to type C:E) for Left and Right(G:K) whatever they input the formula to be copied.

Please Login or Register  to view this content.

Hi karmapala

Thank you for your support. Code is working as expected.

You're welcome, Saran89.
Glad I can help.