I just took over a manufacturing/contracting business and need somebody who can help create some spreadsheets and worksheets which are compatible with Excel 2010 to help me manage projects and data. I need a few different aspects.
1. New Entry form- I want an input form or spreadsheet where I can input new projects and customers and include information about each project, including due dates, kind of project, etc.
2. Progress spreadsheet - I want another worksheet or spreadsheet where I can update information as the project moves along. The information would show what has been completed, what hasn't (including checkmarks if possible). This may be a view only spreadsheet. It would only show open projects. Completed projects would not show on this spreadsheet.
3. Update form/spreadsheet -- This worksheet and also allow me to update progress information and add notes for individual projects. This may be a spreadsheet which just shows open projects. This may also be combined with the Progress Spreadsheet to be one spreadsheet, or it may be a separate spreadsheet or form. This may also be combined with the New Entry form, or it may be separate. This would only include projects that have not been completed.
4. Pricing spreadsheet - on the above spreadsheets, I want to include the pricing of items for projects and some other data (like how many units, how many stitches, etc.) When projects are completed, I want to be able to look all these pricing details up on a spreadsheet. Then, on the spreadsheet, I want to be able to filter the pricing data for each individual company -- telling me how much a customer paid per unit in the past for a project. This information would come from completed projects.
I also want a few additional spreadsheets:
1. Open projects and what stage each project each is at (this can be just for view or the one where I can input the information
2. Pricing spreadsheet - which shows the prices and data about each project, which I can filter to just show data for certain companies.
Data that will be included in these spreadsheets, but may include more:
- Company name (have multiple projects)
- Project Name (and this name may be repeated, as many are re-orders)
- Type of project - new, re-order
- Digitizing - new, adjust, not applicable
- Stages of the project
- Number of units
- Price per unit
- Number of stitches
- PO number
- Invoice number
- Paid or not
I made some preliminary spreadsheets, but cannot figure out how to combine the worksheets and simplify the information. If you are qualified, I will send you the spreadsheets I have and what I am hoping for.
I DO NOT NEED DATA ENTRY. I do not need charts or graphs. I need someone to develop the spreadsheets/worksheets for me.
Hi, I would be glad to help you with this work. If you're interested please contact me. I have a 10 years experience in IT area (did a lot of excel templates with or without the use of macro).
15 freelancers are bidding on average $130 for this job
Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss. Regards. Stay tuned, I'm still working on this proposal.