| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying matched criteria and relevant data columns to a new worksh
"Damon Longworth" wrote in message ... 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 See your message under microsoft.excel.misc for a possible solution. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy data that matches criteria in one worksheet to another worksh | Excel Worksheet Functions | |||
| copying matched data, sort of | Excel Discussion (Misc queries) | |||
| Copying matched criteria plus relevant columns to new worksheet | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| Copying data relevant to the position of a cell on another sheet | Excel Programming | |||
Linear Mode
