Eliminate References and Keep Data

  • Thread starter Thread starter Reed
  • Start date Start date
R

Reed

Hi,

I have 55 workbooks that are filled with formulas that take data from other
workbooks. I would like to get rid of the formulas, but keep the data. I
would like all compiled workbooks to have any references eliminated. How
can this be done?

Thanks,

Reed
 
Reed.

Select the cells, Copy. Now paste-special right over the original cells
with Edit (or right-click) - Paste special - Values.
 
Back
Top