everyday this forecast sheet gets modified with new orders and the orders that have been manufactured get deleted.
Once I type in all the new orders under the perspective machines (G95,G5,K95,G126,QC7) that is going to manufacture the orders I simply copy and paste those into the the certified sheet. Once the quality testing is complete I add the L/W heat and C/W heat numbers. Lot orders are designated by the the thick bold line. These orders need certified for our customers who purchase these styles of mesh. We create these certified reports in filemake pro 11 when ever they are shipped. I have already imported the current certified sheet into FM and need help to figure out how to keep the data in FM updated with the data that goes into excel daily or anytime a change occurs in the production schedule. I want to import only the data that has been added or changed. Everytime I try to import new data it imports what is already there and what was added. Can someone help me figure this out?
This forecast has to be done in excel not FM as others utilize the data in it for other purposes.
here are the files I need help with. Certs-Combined-5-9-2011.xlsx Copy-certs-5-9-2011-Converted.fp7