Thread: Copying matched criteria and relevant data columns to a new worksh
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Damon Longworth Damon Longworth is offline
external usenet poster
  
Posts: 111
Default Copying matched criteria and relevant data columns to a new worksh
Sounds like a job for Advanced Filter. If you want code, you can record the
filter process.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"mattguerilla" wrote in message
...
I want to use code in a macro to search for criteria in a worksheet which
allows the matched data to be copied (along with other relevant columns)
to
another worksheet in the same file. Would this involve some sort of loop?
Any help apreciated.

Thanks in advance,

Matt



Reply With QuoteReply With Quote