This video demonstrates two methods for creating a VBA macro that will only paste values including number formatting. This tutorial will be useful to you where you need to create a copy of data that does not include formulas, just the formula results.
------------------------