Hello All,
I would like do something like, what can remove the row, if 1 cell contaion the value from sheet2. For example:
Sheet1:
A A A
1 a 1 1
2 b 2 2
3 c 3 3
4 d 4 4
Sheet2:
A
1 specific value:
2 2
3 4
And when i run the VBA this just gonna remove the 2. and 4. row and i will get something like this:
A A A
1 a 1 1
2 c 3 3
I would like work with table, so thats why the filter not good idea. Thank you very much!
I would like do something like, what can remove the row, if 1 cell contaion the value from sheet2. For example:
Sheet1:
A A A
1 a 1 1
2 b 2 2
3 c 3 3
4 d 4 4
Sheet2:
A
1 specific value:
2 2
3 4
And when i run the VBA this just gonna remove the 2. and 4. row and i will get something like this:
A A A
1 a 1 1
2 c 3 3
I would like work with table, so thats why the filter not good idea. Thank you very much!