Macro to copy cells based on the value of another cell

the data is like this:

Col A Col B

10
20
30 X
40
50
60 X

i would like a macro to copy only 30 and 60 because there is an "X" against them in column B.

i would like the macro to copy this values on the clipboard or a list with no blanks..

can anyone help? thanx

This first bit of code will work providing that x is found nowehere else in the sheet except in the column next to the data you want to transfer

Please Login or Register  to view this content.

This is a slightly modified version which restricts the search range to just the column next to the data so will work if x can be found elsewhere in the speardsheet.

Please Login or Register  to view this content.

Just change the column references as needed.

Hope this helps, Robyn

PS I have no idea how to copy values to the clipboard so can't help there, sorry

Please Login or Register  to view this content.