I'd apply data|Filter|autofilter and filter C33:C77 to show the cells that
contain ACS and then copy those visible rows to that other range.

Shelly wrote:

Thanks for the quick replies... I've tried the macro and ISERROR, but now I
see the need is more comlicated.

The range that I am searching is C33 through C77 (in Worksheet1)
If any of these cells contain the string "ACS"
I need the value of that cell to also be put into a cell in the 2nd worksheet
but the range for this is only A8 through A20

So the "target" isn't the same cell as the "source".

At no time will the source list (C33 - C77) return more values than will fit
in the target list (A8 - A20).

Much Thanks!

--

Dave Peterson