Copying matched criteria and relevant data columns to a new worksh

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

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" <[email protected]> wrote in message
news:[email protected]...
>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
>

"Damon Longworth" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> >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
> >
>
>

See your message under microsoft.excel.misc for a possible solution.