Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying select cells using VB
Hi, Appologies if my title isnt clear but i cant describe what i want t do! I have a large spreadsheet with many rows and wish to extrac certain details (all columns in a row) if a specific feature is foun in the rows. The feature i am looking for is that if h4..h5..h6.. etc has 'a' or 'b or 'c' then i want the entire row of 4,5,6etc to be copied into a ne sheet..giving me a new sheet containing all the details for the row that contained an 'a' 'b' or 'c'. I wish to automate this by using a button but have no idea where t start... please please help me ow wise ones! -- jagbabbr ----------------------------------------------------------------------- jagbabbra's Profile: http://www.excelforum.com/member.php...fo&userid=3252 View this thread: http://www.excelforum.com/showthread.php?threadid=52307 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Select Repeating Cells in a Column | Excel Worksheet Functions | |||
Up down arrow keys do not select cells if select locked cells unch | Excel Discussion (Misc queries) | |||
Macro to select cells without a certain value and select a menu it | Excel Worksheet Functions | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) |