Advanced Excel Question, Macro

I want to paste data into Sheet1 of a Workbook with multiple Sheets. I then want Excel immediatly erase any row where the value of the cell in Col 2 matches that of any cell in Col2 of any other Sheet within the Workbook.

Make sense? Any suggestions?

 

Hi,

You dont say if there is a particular row you want to paste into. Anyway, I suggest you run the Macro facility for building it. Go through each stage that you want including FIND on the other pages. Once you have done all you want it to do save it and give it a name. Each time you then run the macro it will do what you have set it up to do

Hope this is useful