| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
select records with a specific value
How can I select only those records with a "1" in col A and highlight only
col C of the same record(s) for copying? I'd like to put this in a Macro. Thanks -- Al |
|
#2
|
|||
|
|||
|
Al,
Columns("A:A").AutoFilter Field:=1, Criteria1:="1" Intersect(Columns("C:C"), ActiveSheet.UsedRange) _ .SpecialCells(xlCellTypeVisible).Copy HTH, Bernie MS Excel MVP "AMK" wrote in message ... How can I select only those records with a "1" in col A and highlight only col C of the same record(s) for copying? I'd like to put this in a Macro. Thanks -- Al |
|
#3
|
|||
|
|||
|
entered your suggestion into a macro as follows:
Columns("A:A").AutoFilter Field:=1, Criteria1:="1" Intersect(Columns("C:C"), ActiveSheet.UsedRange _ .SpecialCells(xlCellTypeVisible).Copy Will not run????? Please let me know if i'm misrepresenting something. Thanks -- Al "Bernie Deitrick" wrote: Al, Columns("A:A").AutoFilter Field:=1, Criteria1:="1" Intersect(Columns("C:C"), ActiveSheet.UsedRange) _ .SpecialCells(xlCellTypeVisible).Copy HTH, Bernie MS Excel MVP "AMK" wrote in message ... How can I select only those records with a "1" in col A and highlight only col C of the same record(s) for copying? I'd like to put this in a Macro. Thanks -- Al |
|
#4
|
|||
|
|||
|
Al,
What error messages do you get? Is the sheet of interest active at the time? Are you using a commandbutton, or using Tools / Macro/Run? Where did you put the code? Bernie "AMK" wrote in message ... entered your suggestion into a macro as follows: Columns("A:A").AutoFilter Field:=1, Criteria1:="1" Intersect(Columns("C:C"), ActiveSheet.UsedRange _ .SpecialCells(xlCellTypeVisible).Copy Will not run????? Please let me know if i'm misrepresenting something. Thanks -- Al "Bernie Deitrick" wrote: Al, Columns("A:A").AutoFilter Field:=1, Criteria1:="1" Intersect(Columns("C:C"), ActiveSheet.UsedRange) _ .SpecialCells(xlCellTypeVisible).Copy HTH, Bernie MS Excel MVP "AMK" wrote in message ... How can I select only those records with a "1" in col A and highlight only col C of the same record(s) for copying? I'd like to put this in a Macro. Thanks -- Al |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting specific records from a column | Excel Discussion (Misc queries) | |||
| Select specific cell | Excel Discussion (Misc queries) | |||
| How do I pause a macro to select specific cells | Excel Worksheet Functions | |||
| How do I select only specific parts of one field? | Excel Worksheet Functions | |||
| Number of records by Month that meet a specific requirement | Excel Worksheet Functions | |||
Hybrid Mode
