Hello Wise ones,

I have multi-user workbook in which one sheet has ref #
that user can past in 2nd sheet to pull various lookup data from 3rd hidden
sheet.

it is mostly cosmetic ( pet peeve ) that user doesn't past values only.

is there a macro / way to only paste values and keep dest format in
destination cell?

border / font / color all being effected.

thanks , Steven - Dallas