Hi All,

I have a worksheet with several lookup formulas to populate data and several multiplication formulas to determine price totals. When I release this worksheet to coworkers I would like the formulas for determining price to still function, but I would like the lookup formulas to be replaced with just the required data. So I would like to write a macro that copies a range of cells (A2:E84) and then pastes that data back into the same range as values only. I can do it manually and it works, but I know there is a way to do it quicker with a macro, I'm just not skilled enough with VBA to figure it out.