Eliminate References and Keep Data

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
 
E

Earl Kiosterud

Reed.

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