Copy Paste Problem!!

[Woelfe]

Hello everyone. I'm having an issue here I'm not sure how to solve. I have a lookup formula on sheet 1 of my spreadsheet that returns me the name of a college based on a code that it looks up from another sheet.

Now I'm trying to copy and paste the names of these colleges into another worksheet but when I do that it flips to #N/A because I'm copying a formula.

Is there anyway for me to copy and paste these names so that the formula doesn't wipe it out? Does this make sense??

Thanks in advance for your wisdom!!

-Woe

 

[Andrew Poulsom]

Use Paste Special, Values instead of Paste.

 

[Woelfe]

[No message]

 

[Woelfe]

Andrew,

Thanks!!!! I figured there was a way to do it!!

Awesome =)

-Woe