Manufacturing Orders Generator and Open Status Board for shop..

$250-750 USD

Completed

Posted

about 4 years ago

$250-750 USD

Paid on delivery

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.

Project ID: 24215000

About the project

5 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

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 convention "MO" followed by col Q value. I can also generate a Status Board Report with timestamp that can be used to display on a monitor. Being a full time freelancer working exclusively on Excel based projects, I work on developing macros every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi

$250 USD in 3 days

5.0

(220 reviews)

7.0

5 freelancers are bidding on average $455 USD 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?w=f From the Microsoft Excel and Access, of course, familiar. Regards, Vladimir

$300 USD in 7 days

4.9

(228 reviews)

7.0

@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 : "Access Attendance", "Invoice & book-keeping management" and " Create sales and purchases database application" . Those 3 app-s will give you a view what/how I can code for your project via Ms Access. Besides, I can provide access to any my MS Access application. I can code all based on your instructions - professionally and on time. I’m Ms Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid. I hope hearing from you soon. Thank you for your consideration and Regards, Zurab

$500 USD in 7 days

4.6

(65 reviews)

6.4

@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 project. Also, have a look at my profile for my reviews and portfolios. Thanks Note: This is not an automated bid and i'm ready to discuss your project right now. .. .

$750 USD in 4 days