Another Simple Question

[dick_007]

Ok i thought i had finally finished my massive database...but i have hit another snag (this will be the last one (hopefully)) The problem is i want to copy a cell from one worksheet to another. It is easy to do this if it is simple data cell...but the catch is the data is displayed through the formula :

e.g.
=IF(D6=1,"Client",IF(D6=2,"Potential Client",IF(D6=3,"Referral Source","")))
Obviously if i copy i get an error reference.

I also cannot just do:
='Add Client'!E6
Because once I add more data all the previous values will update as well.

Does anybody know a shortcut around this?? Or proberbly more to the point does anybody understand what i mean???

 

[whiteghost]

try "copy, paste special , values" from the edit menu

 

[dick_007]

Worked a great THANKYOU!!!

I am so happy i could kiss you...well...

1. If you weren't in Hong Kong and I in Australia
2. I actually kissed boys

If you can forget those two limitations then i could kiss you!