If you want to copy over formula from one sheet to the other without linking
to the original sheet?

ctrl + H, replace e = with ^=^, select the ranges you want to copy, copy and
paste into the new sheet,
reverse the replace and replace ^=^ with = on both sheets

--
Regards,

Peo Sjoblom

Portland, Oregon




"Roger" wrote in message
...
How would I copy & paste to a new sheet the format & formula but not the
data