Deleting formula links

  • Thread starter Thread starter Rook
  • Start date Start date
R

Rook

Hi Everybody, this is my first post here, and all of the help I'v
gotten from the site has been great!

I have a spreadsheet that gets all of it's information from anothe
document. Pretty much all of the cells use the vlookup function. Th
sheet that the vlookup function gets it's data from will be changing o
a regular basis, so I need to know if there is a way to remove th
formula from each of the cells and leave only the value. Can this b
done?

Here's an example if my explanation is unclear.

Cells D2:D60 contain variations of the formula
=VLOOKUP(A9,Stats2!A1:BZ85,55,FALSE)

The Stats2 sheet that the formula references for it's data is update
on a weekly basis, however I need to keep the information fo
historacle reporting purposes. Is there a way to remove the formul
while leaving the value in the cell
 
If you want to keep a carbon copy of the sheet for history, then create a file
called History.xls for example, and then with that file open too, right click on
the tab of the sheet you want to keep a copy of, then select 'move or copy',
tick 'create copy' and then choose the History file from the dropdown as the
place to copy it to. This will throw you into the history file. Now in the
history file, do CTRL+A, then Edit / Copy, then Edit / Paste Special / Values.
Name your tab with the date and you are done.
 
Back
Top