VBA code to filter data

Hello

Can anyone help me to figure out a macro that will do the following:

It should copy/past the whole row in Sheet 2 of numbers in column A if this number has only Q5 at the end if the number has both Q5 and Q6 so it shouldn´t copy/paste the row in Sheet2

For example 567 has both Q5 & Q6 at the end so the row shouldn´t be copied/pasted in Sheet2


Thanks in advance!!

Originally Posted by Dunc3142

This might work for you. after using the formulas, if you need the data to be together, you could do a select all, Copy, Paste Special and choose values. then sort the data.

Thanks a alot Dunc3142 for you quick respons but this function is not applying the condition that is if the same number on the column A (Sheet1) has both Q5 and Q6 at the end so it shouldn´t show up in Sheet2. As it is the case here for 567Q5, it shouldn´t be in Sheet2 because there is 567Q6 in Sheet1 column A. Your function will copy/paste all numbers with Q5 at the end

I wrote this can someone please help me to fix it:

Thanks

Please Login or Register  to view this content.