Thanks Luke... i am not sure either, really struggling... I had TWO sets of DATA,I compared the Data using 'VLOOKUP' to show me the 500 records that were unique or (#N/A) against the 3.5K records I already had. I then used the 'FILTER' button to simply show me the 500 companies ONLY.... I now...
I have managed to sort my unique data i have uysed the filter in the sheet to show me the unique companies... I now need to move the 'unique' companies into a seperate sheet/book so I can save as a CSV and upload it to my database... Each time I do this it deletes the info... what am i doing...