Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select rows based on a value in a column
I'm a newbie in need of some experienced programmers here. I am wanting to create a macro that will select rows based on a TRUE value in column B of my spreadsheet. I know this is probuly very easy, but i'm new to this and have been running around in circles for the last couple of days. Attached is a view of what the first few rows of my spreadsheet look like. My final intent is to insert all rows that contain the TRUE value into a report on Sheet2. I can handle the programming of the copying and pasting into certain areas, but so far i have been unsuccessfull at being able to select the rows. Thank you in advance for helping me.. -James +-------------------------------------------------------------------+ |Filename: qoute spread.jpg | |Download: http://www.excelforum.com/attachment.php?postid=3591 | +-------------------------------------------------------------------+ -- raceachvy ------------------------------------------------------------------------ raceachvy's Profile: http://www.excelforum.com/member.php...o&userid=25126 View this thread: http://www.excelforum.com/showthread...hreadid=386287 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select rows based on a value in a column
Hi
Look here for a AutoFilter example http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "raceachvy" wrote in message ... I'm a newbie in need of some experienced programmers here. I am wanting to create a macro that will select rows based on a TRUE value in column B of my spreadsheet. I know this is probuly very easy, but i'm new to this and have been running around in circles for the last couple of days. Attached is a view of what the first few rows of my spreadsheet look like. My final intent is to insert all rows that contain the TRUE value into a report on Sheet2. I can handle the programming of the copying and pasting into certain areas, but so far i have been unsuccessfull at being able to select the rows. Thank you in advance for helping me.. -James +-------------------------------------------------------------------+ |Filename: qoute spread.jpg | |Download: http://www.excelforum.com/attachment.php?postid=3591 | +-------------------------------------------------------------------+ -- raceachvy ------------------------------------------------------------------------ raceachvy's Profile: http://www.excelforum.com/member.php...o&userid=25126 View this thread: http://www.excelforum.com/showthread...hreadid=386287 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select rows based on a value in a column
I've been doing some things like i want to with filters, but it doesn't select the whole row, and then copy it. Is there any way to program a macro to select the rows that contain "TRUE"? -- raceachvy ------------------------------------------------------------------------ raceachvy's Profile: http://www.excelforum.com/member.php...o&userid=25126 View this thread: http://www.excelforum.com/showthread...hreadid=386287 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help tonight?!! select rows based on cell value in a column | Excel Worksheet Functions | |||
Macro to Hide rows based on value of column F | Excel Discussion (Misc queries) | |||
Need to select rows to average based on a value in a different column | New Users to Excel | |||
how would i select a group of rows based on a column value | Excel Programming | |||
Is there a smart way to select multiple rows based on column... | Excel Programming |