I am trying to see if there is a macro that I can use in a Master file that will check a Template file, and based on a letter in Column I, will move certain data to the Master file and update it. Each letter in Column I will have it's own argument. For example:
If the letter in Column I of the Template file = A, Match the account number in Column A of the Template file to Column A of the Master file, and ADD the data from Column B, or Column C, or Column D, or Column E, or Column F, or Column G, or Column H of the Template file to the existing record in the same column of the Master file.
If the letter in Column I of the Template file = C, Match the account number in Column A of the Template file to Column A of the Master file, and CHANGE the data from Column B, or Column C, or Column D, or Column E, or Column F, or Column G, or Column H of the Template file to the existing record in the same column of the Master file.
If the letter in Column I of the Template file = D, Match the account number in Column A of the Template file to Column A of the Master file, and DELETE the data from Column B, or Column C, or Column D, or Column E, or Column F, or Column G, or Column H of the Template file from the existing record in the same column of the Master file.
Basically, I want to be able to have people enter additions, changes, and deletions into the Template file, and when I run the VBA macro in the Master file, it enacts those changes automatically without having to manually key each update. The columns in each workbook are exactly the same as far as number of columns and headers. The Master file with contain approx. 5,000 records that only occur once, no duplicates, but the Template file may have duplicates based on how many time something is altered, however that could be worked around if needed to avoid errors.
I have attached examples of the Master File and Template File.
Thanks!
Bookmarks