Завершен

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.

Навыки: Excel, Excel VBA, Excel Macros, Microsoft Access, Разработка баз данных

Показать больше: 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

О работодателе:
( 0 отзыв(-а, -ов) ) Catoosa, United States

ID проекта: #24215000

Поручен:

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 Больше

$250 USD за 3 дней(-я)
(199 отзывов(-а))
6.8

6 фрилансеров(-а) готовы выполнить эту работу в среднем за $421

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? Больше

$300 USD за 7 дней(-я)
(181 отзывов(-а))
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 : " Больше

$500 USD за 7 дней(-я)
(56 отзывов(-а))
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 Больше

$750 USD за 4 дней(-я)
(5 отзывов(-а))
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 Больше

$250 USD за 3 дней(-я)
(3 отзывов(-а))
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 за 7 дней(-я)
(0 отзывов(-а))
0.0