I have an Excel file which have 3 sheets ( Databse , Quotes , Report).
I want a Macro to check Column A in sheet (Quotes) Range (A2 :A.lastRow)
and to look for those values in sheet (Database) in Column (S) ...
If found then to copy the enitre row to sheet (Report) Range starting from (A4).
I attached a sample sheet for your ref.
If possible to make it in a new vision like copy all rows from Database sheet to Report sheet then make the application.screenupdate =true while deleting the others rows which do not equal to Column A in sheet (Quotes) .. i hope you get my point , when the macro run it will show how the rows are nicely pasted on the sheet report like someone is typing them ;)
Anyway this is not a must .. but would appreciate it a lot.
Thanks and Brgds