I have a file that I initially load to get my starting maaster worksheet (FFLInquiries), and then will load weekly updated files (FFLWeeklyUpdates) each week. What I am looking to do is to update the date the file was uploaded to the master under the appropriate column headings. Example. From the original weekly file I would add all of the personal information like Inquiry date, First Name, Last Name, Lead Status and email as well as adding the date the file was ran under the FFL Inquiry Column on the master. As any change that are made to this, like FFL Assignment, I would keep the date for FFL Inquiry and add the new date for FFL Assignment on the master, etc.
Here is the initial example of the master sheet:
After a running an updated weekly export, this is the new information I would like on the master.
The file that contains the data for the weekly upload looks like this:
I can get the initial load to work and add dates where I want them, but am stuck on how to keep the old values, add the new values in the appropriate columns and rows and add new people to the list.
Any assistance would be greatly appreciated! Thanks
Here is the initial example of the master sheet:
After a running an updated weekly export, this is the new information I would like on the master.
The file that contains the data for the weekly upload looks like this:
I can get the initial load to work and add dates where I want them, but am stuck on how to keep the old values, add the new values in the appropriate columns and rows and add new people to the list.
Any assistance would be greatly appreciated! Thanks
