View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] joseph_m_kaiser@yahoo.com is offline
external usenet poster
 
Posts: 2
Default HELP WITH AN EXCEL PROBLEM

I have a data sheet containing 10k rows of survey data. I would like to
know if anyone could help me with a macro that would
1.prompt me for a search term ie. "earthlink"
2.go through all 10000 rows of data in column C and copy the cells that
contain the search term
3.paste the cells in the same row # only in column E.

Is this possible to do? It would save me sooooo much time. I would be
very grateful if anyone would help me with this.
Thanks in advance
Joe