G
Guest
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
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