Hi all I am new to the forum, and fairly new to VBA so still finding my way around. I have done some searching on the internet and various forums but I am struggling to find any answers.
I have a workbook with 3 sheets - "2016", "Payment Plan" and "Paid" On the sheet "2016" I have reference numbers in column A with various other details in corresponding columns upto column G. Sheet "Payment Plan" is the same as sheet "2016" but does not contain all of the records - the reference numbers in Column A will match to column A on sheet "2016". What I am looking to do is when "Paid" is entered into column H on sheet "2016" I want to search for the contents of column A in that row, on the "Payment Plan" sheet and if a match is found delete the entire row, and ALSO copy the whole row from sheet "2016" to the last row on the "Paid" sheet and then delete from the "2016" sheet. Is this possible to do using VBA? I would greatly appreciate any help on this matter
Thanks
JP
Bookmarks