copying the results

[CYBERGUY81]

hi i want to copy a coloumn from one sheet to another but in that coloumn there are formulas that refrence other cells all i want to do is copy the result of the formula and not the formula it self. thanx for ure help

 

[Steve Hartman]

Edit > Paste Special > values

 

[CYBERGUY81]

now i feel stupid... thanx a lot for ure help

 

[Steve Hartman]

Don't feel stupid...it was just a piece of info you didn't have before.