View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pam[_3_] Pam[_3_] is offline
external usenet poster
 
Posts: 56
Default if, then, replace text

Hi,

I have a worksheet with columns "Merch" (Column I), "Margin" (Column K) and
"Terms" (Column P). What I want to do is, if Terms = CC, replace Merch $
amount with Margin $ amount? Is this possible with code?

Any help would be greatly appreciated.
Thanks in advance,
Pam