View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jhahes[_71_] jhahes[_71_] is offline
external usenet poster
 
Posts: 1
Default put cells based on condition in sheet2


Could someone please help me do the following....

In Sheet1 column a I have about 5000 entries.....What I would like t
do is have a code that loops thru all entries...all entries would b
text strings...

if it finds info411.com in any part of the cell then cut and paste i
it shee2 column a in the first open cell....then repeat the proces
thru the loop.

so if 200 cells in Sheet1 Column A contained infro411.com then the
would be cut and there would be 200 cells in Sheet2 Column a that woul
now contain them...

thank you for any hel

--
jhahe
-----------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...fo&userid=2359
View this thread: http://www.excelforum.com/showthread.php?threadid=56917