software

I have used a simple IF formula to pull data from another file, but once i
have pulled this information over i wont it to be saved as the actual data.
Because the file i have 'if' copied the data over from is updated every
month, and i dont wont the data on the new my sheet to be over copied each
timeits opened. How do i do this?

Before saving your worbook:
select your cell
Copy
Paste Specialgt;Values

HTH
--
AP

quot;Timquot; gt; a écrit dans le message de
...
gt;
gt; I have used a simple IF formula to pull data from another file, but once i
gt; have pulled this information over i wont it to be saved as the actual
data.
gt; Because the file i have 'if' copied the data over from is updated every
gt; month, and i dont wont the data on the new my sheet to be over copied each
gt; timeits opened. How do i do this?