I want the macro to copy data in one worksheet and paste the values into another worksheet. The Worksheet from which the macro is copying data from has formulas and I want it to paste just the values and formatting into a different workksheet..

Thanks.