I have this simple spreadsheet that I use to creating manufacturing orders or my shop so they know what to work on. in Column Q thru AJ, I simply paste Bill of Material information I get directly out of our SolidWorks drafting software. the manufacturing order in columns A thru L simply grabs the necessary information from the paste I do. I then click on FILE, EXPORT, CREATE PDF.. I manually name the file MO and whatever is in field Q2 and hit generate, it looks like "MO 666-2-1295". The PDF version of the MO is saved in a folder on my desktop . Then I go and delete fields O2 thru AJ2 and the next line of data moves up and I repeat the process.
What I am wanting to do is after I paste the initial information I would like excel to automatically created all the PDFs in the list and save them based on my "MO XXX-X-XXXX' format.
I would also like to create a separate file (access / excel??) that I can display on a monitor out in the shop of all the manufacturing orders I created and a time stamp when they were created. On this file I don't what the information to delete I just want to keep adding lines to it. Like a running history.. I want to be able to go into this file and delete the information after the parts are built. I made a sample of what I am looking for here on the second tab of the excel file I attached. this doesn't have to exist in this same file, I just pasted in here your benefit.