Hello,
Much appreciation for your time and knowledge about VBA/excel.
The following macro is intended to complete a data set; it uses the Lookup function to see if a particular value (primary key for a record) is found in the data set, and if not then it will add it else move on to next record.
It looks through a list of primary keys and the lookup function works on most of the records, but then errors out about 2/3 the way through the list.
Attached is the file and here's the particular section of the code in module 5 (a private sub initiated from code in module 4):
October PPA List_Template_Example.xlsm
Bookmarks