Copying excel data without disrupting cell reference??

[Lorna087]

Hi just wondering if anyone can help me with this.. I've created dummy variables in one workbook and trying to copy them to another but the cell reference is changing to the cells in the new workbook.. I know this probably sounds very muzzled but I cant seem to explain it well.. any help??

 

[SteveO59L]

Try searching the help for Absolute Reference

 

[brans1982]

Hi,

Instead of copying the formulas, in the new workbook type "=" into the cell you want the value to be in and then point to the relavant cell in the workbook with the dummy variables.

 

[Lorna087]

Thanks everyone.. I ended up just copying and pasting it to the clipboard so that seemed to work