View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shelly Shelly is offline
external usenet poster
 
Posts: 84
Default How to determine if a cell has a value, then copy it to a new loca

Hello,

I need to determine if a cell in one worksheet has a specific string of
characters, and if yes, copy the entire cell to a second worksheet.

So,

If 'Worksheet1!a1' contains the string "ACS", copy the content of
'Worksheet1!a1' to 'Worksheet2!a1'

I've tried several things I've found on this BB, but not luck so far.

THANKS!