Hi
I'm very new to writing Macros and VBA so wondering if anybody can help.
I have attached a sample workbook.
I am trying to write a macro that if a cell in column A on Sheet1 is clicked a search is performed for the value in column D to see if it already resides in column A on Sheet2. If it does then a message box is displayed else some of the row cotents is copied to over to Sheet2 (the columns don't match like for like).
Here is my simple code so far:
On Sheet1:
In Module 1:
I've searched for simlar problems and can't figure out how to stop using set cells/ranges and make it look at the clicked row. Also how to append each new copied row under the previous one on Sheet2.
Any help appreciated.
Yxx
Bookmarks