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?