I have attached two worksheets. These are from two different sources. The destination file is used to upload financials into a DB. I cannot change the structure of this file, only the numbers. The second file, Source, is a Pivot Table created from MSProject output (Raw Sheet) which I can play with. What I now need to do is find all of the entries in the Source Pivot Table that matches existing data in Destination and overwrite it or zero it out.
For example. There is a Task 000 in Destination that does not exist in Source, therefore I need to clear all of the cells in mint green only for the future, but leave the data that occured in the past. For Task 207 which exists in both Source and Destination, I need to match the data by Task, Date and Class and write it to the appropriate cell in Destination. (Notes: WBSTask and Task are really the same. There are actually formualas in the grey cells, but I'm not currently conserned with them, so I left them out.)
I really don't even know where to get started outside of the fact that I have to walk the cells, but I would like to do it in the most efficient way possible as some of these files can get really big. We are currently doing it manually for about a bzillion items amd it's getting old. If one of y'all gurus could get me started, I would forever be in your debt!
Thanks!!!
SherryO