Remove the data from sheet one....When i will have the macro ready, i need the sheet one to be empty..As and when i will add the data it should work accordingly. Thanks