copy from previous three columns and paste in next three columns.

**Divyac** · 07-24-2009, 04:12 AM

Hi...

I have a query wherein in I require to create a macro which will help me in copying the formula in the previous three columns to the next three columns everytime when the macro runs..

Attached is the file for reference...

Thanks alot for the help

**ravishankar** · 07-24-2009, 05:22 AM

Hi
Check if the macro in the attached file serves your purpose. It does not copy formula but calculates values using formula and inserts values in columns.
ravi

**Divyac** · 07-24-2009, 09:41 AM

Hi Ravi,

The macro given is working for the first three columns. But the data in the sheet 2 is changed every week and thereby a vlookup is done again in sheet 1in the next 3 columns in the attached (column D, E, F) and the data in column A,B & C needs to be retained as well.. In short when a macro is run the next three blank columns need to be filled...

Thanks alot for the help

**ravishankar** · 07-25-2009, 01:14 PM

Hi
Modified macro is attached
Ravi

**Divyac** · 07-27-2009, 11:33 AM

Hi Ravi...

Thank you so much

the macro is working perfectly....
Thank you again..

Regards,
Divya..

**Divyac** · 07-28-2009, 09:24 AM

Hi Ravi..

Have a query with the same macro wherein in the attached file Iam unable to run the macro with the original data. The same was working fine with the sample file I sent.
Please help me as Iam new to the concept of macro.

Regards,
Divya.