If Sheet2_Col_C is "just text", then how does copying from
Sheet1_Col_B to Sheet2_Col_B affect Sheet2_Col_C? At least that's the
way I read your #1. I can understand Col_C being affected if it has a
formula, but not if it "just text."

Hth,
Merjet