Copying of an excel worksheet (having formula) to another workbook sheet with only value

Sep 23, 2014 at 12:06 PM
I have a scenario where I need to copy an excel worksheet having calculated value(means formula on the respective cell) to another worksheet of different workbook. My Issue is that is their anyway to copy only the value (not formula)of sheet without formula .Currently formula is also coming.