Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA, copy lines with specific value
Hi all,
Can someone advice me which VBA statement to use for substracting a range of lines that match with for example the value in column A, and subsequently copy them (whole line) to an empty sheet (say "Sheet2") Lookup value in column A: CCC A B C 1 AAA 123 111 2 CCC 345 222 3 BBB 678 333 4 CCC 912 444 Result: line 2 & 4 Any suggestions is mostly appreciated. Thanks a lot! Rgds, Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to modify specific lines in a .ini file? | Excel Discussion (Misc queries) | |||
printing specific lines | Excel Discussion (Misc queries) | |||
How do I get page down to move a specific # of lines in Excel? | Excel Worksheet Functions | |||
Detect lines in specific sheet at load time | Excel Programming | |||
Print only lines that have a value in a specific colum | Setting up and Configuration of Excel |