Help! I need to create the following VBA:
It needs to look at sheet1, columnA and see if the word "rec" appears.
If yes, it then needs to compare the contents of that respective row's column N to the whole of Column N in sheet 1 of a different workbook.
If it matches the column N data, then it needs to do nothing.
If it cannot find columnN data then it needs to copy the row of data across A-N from the original sheet into the new sheet in the next available empty row.
Thank you and I hope this is clear enough!!
It needs to look at sheet1, columnA and see if the word "rec" appears.
If yes, it then needs to compare the contents of that respective row's column N to the whole of Column N in sheet 1 of a different workbook.
If it matches the column N data, then it needs to do nothing.
If it cannot find columnN data then it needs to copy the row of data across A-N from the original sheet into the new sheet in the next available empty row.
Thank you and I hope this is clear enough!!
