Copy formulaes to next column and make the previous data static(remove the formulaes)

Hi,

I am creating a weekly report wherein I use some formulaes to create the summary. I would like to know how to copy formulaes from one column to next on a button click and then remove formulaes from previous col. Help is much appreciated.

Attached is a sample xls

Hi All,

Can anyone help me onto this?

To give in more detail

COL D has formulaes already.
Step1:Now on button click, I would need to move formulaes from Col D to Col E( next blank column)
Step2:remove formulaes from Col D ( make the data static)

hi,

i'm no expert, but I can give it a shot

Please Login or Register  to view this content.

This is what you need

Please Login or Register  to view this content.

You can get codes by recording the macro. Then you can tweak as required.