Hi,
I have a big problem that makes me feel naucius . The thing is this; I have two excel files (2007 and 2008), almost identical, containing one sheet with raw data and one sheet that turns the data into a nice report (some other sheets as well but that doesnt matter I think...).
I have now made alot of changes in the "report" sheet for this year, and would like to copy it to the 2007 file. However if i mark and copy-paste all cells, all formulas still poin to this years file with raw data. Same thing when i copy the whole sheet.
Swapping the raw data sheets turns the "report" sheet into a big mess of reference errors...
So, how can i copy a whole sheet and keep the links? Im sure it can be done some way...or my weekend is ruined
Thanks in advance!
/Johan
Bookmarks