Can I look for a text value in a sheet and copy it to another location.
For Example,

I looking for all the "Cat" and want to copy it to another locations

Hello,
Use a macro with a code something like
public sub FindCatAndPaste()
Cells.Find(What:="cat", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:=False _
, SearchFormat:=False).Activate
Selection.Copy
Range("L19").Select
ActiveSheet.Paste
End Sub

abd then use it any way you wish..

Pranav Wagh

"The Real Stuff Is oUT oF tHE bOX"

http://blogs.msdn.com/pranavwagh


--------------------
Thread-Topic: If statements
thread-index: AcY+9UsEXgKtcsXfTLKQZUGlxiwcmw==
X-WBNR-Posting-Host: 71.153.222.238
From: ?B?TmV2ZXJCZXR0ZXI=?=
Subject: If statements
Date: Fri, 3 Mar 2006 11:04:27 -0800
Lines: 4
Message-ID:
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.excel.programming
Path: TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.excel.programming:709087
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.excel.programming

Can I look for a text value in a sheet and copy it to another location.
For Example,

I looking for all the "Cat" and want to copy it to another locations