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:
Thanks!
- 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.
Thanks!