code explanation and suggestion

What I am trying to do is search in column E in sheet 1 for any data in column F and L in sheet 2. If this data don't apear I want this data to put in last row of column L in sheet 2.

I also want to do a search in column E in sheet 1 for any data in column B only in sheet 2. If this data don't appear I want this data to be put row 3 and so on in column D of sheet 3.

The code I have on the bottom does this but sometimes it doesn't pick up certain data. For example if "A", "apple" ,etc data from column E sheet 1 is not in column F or L of sheet 2, it doesn't put it to last row of column L in sheet 2 and for other datas it will do it. So I am not sure why it isn't picking up certain data when the code are correct.

Please Login or Register  to view this content.

Let me know if you have a better code that will do this and does it everytime for all datas that are not there as explained above.

thanks

You might like to try this for your first Query, if it suits your needs you could modify it for your second Query
Assumptions:-
Row (1) in sheets (1) & (2) have Headers. (Not Searched)
Search compares Data in Sht(1) column "E", with data in Sht(2) columns "F" & "L"
Data in sht (1) that is not found in Sht(2) is appended to the bottom of Sht(2) column"L" data.

Code.

Please Login or Register  to view this content.

If you run this code twice the second time the items found should be "0" showing that sht(1) data can now be found in Sht(2) data, Hopefully !!

Regards Mick

thanks ~