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 |
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 |