Hello everyone,
I really hope someone can help me. I am trying to achieve some sort of auto fill from a master Excel sheet. Some back ground. We have a master Excel sheet, which is completed every time we receive a new order. From there various departments created different Excel sheets to pull the information through to their respective data bases. Now the issue I have is that I use the information on the sheet to create an Excel History sheet, Checklist and some other forms where we manually capture the same data. These documents are then uploaded to SharePoint and completed live as we move through the various stages of the job. These same forms are populated many times every day. Is there a way to automatically create a new form with certain criteria filled in once the master sheet is updated? We have a field which stipulate what type of job it is and different forms are used depending one the type of job. Any feedback would be greatly appreciated