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