Completed

Manufacturing Orders Generator and Open Status Board for shop..

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.

Skills: Excel, Excel VBA, Excel Macros, Microsoft Access, Database Development

See more: budget open online print shop, hotel room status board, room status board, status board hotel, open source flash shop, diagram generator open source, prestashop customer shop status view shop prices, generator myspace bulletin board layouts, code generator open source, generator open source, licences key generator open source, restaurant table status board, brochure generator open source, licence generator open source, code generator open source webpage, open cart clothing shop examples, key code generator open source, proposal generator open sourcen drag drop

About the Employer:
( 0 reviews ) Catoosa, United States

Project ID: #24215000

Awarded to:

ksriniravi

Greetings! Thanks for very clear requirements. I can implement a macro such that for each line item, one individual PDF is created continuously without user intervention. The PDF file name would follow the naming conv More

$250 USD in 3 days
(199 Reviews)
6.8

6 freelancers are bidding on average $421 for this job

VladimirLilenko

Hello! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko? More

$300 USD in 7 days
(181 Reviews)
6.7
zu02

Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VBA. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f and see following screens for : " More

$500 USD in 7 days
(56 Reviews)
6.2
liveexperts123

Hi there, we are a team of titanium certified developers. we excel inAutoCAD and solidworks enviroment along with unity and unity 3D. please leave a message on my chat so we can discuss the budget and deadline of the More

$750 USD in 4 days
(5 Reviews)
4.8
nemanjadj20

Hello? I have worked on Excel/Word/PPT/MACRO projects to what you are looking for, and I am confident I can exceed your expectations. Thank you for your time. I have attached samples of work very similar to what you More

$250 USD in 3 days
(3 Reviews)
3.5
ajkhan86

Hi I am the person who can do it within a time, give me a chance to work with your organization thanks

$475 USD in 7 days
(0 Reviews)
0.0