Ditutup

Spreadsheets and forms on Excel - 19/12/2017 13:26 EST

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.

Kemahiran: Excel Macros

Lihat lagi: 12 13 26 nemanja vicic https www freelancer com, copying spreadsheets directory excel, aspnet forms excel, how to create a form in excel 2016, excel data entry form template, excel data entry form, how to create a data entry form in excel 2013, how to create a fillable form in excel 2016, excel forms template, how to create a data entry form in excel 2016, excel data entry form examples, data processing, excel, visual basic, visual basic for apps, microsoft excel, data capture forms excel, vba forms excel, photographer forms excel, pdf forms excel

Tentang Majikan:
( 0 ulasan ) India

ID Projek: #15907292

21 pekerja bebas membida secara purata $186 untuk pekerjaan ini

WesleyJeftha

Good day, I am an English speaking university graduate with 17 years experience using excel to solve complex business problems. My key strengths include: Web Scraping, User Input Form Creation, Business Intellige Lagi

$277 USD dalam 5 hari
(5 Ulasan)
4.0
vmadhavan15

I am not a random bidder.. I hope I can do this one for you... Please ping me if you are interested with my proposal and thank you...

$250 USD dalam 3 hari
(9 Ulasan)
4.0
osmemon

I have 7 years of experience in Excel and VBA with 100% client satisfaction history. See my profile for client reviews and portfolio

$250 USD dalam 3 hari
(4 Ulasan)
3.3
jasalaz100

Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing a Lagi

$200 USD dalam 3 hari
(6 Ulasan)
3.3
rohitpithisaria

Hello I am an excel expert and have completed more than 150 projects in it. I would like to bid on the project posted by you. I have read your requirements regarding the various excel sheets though I have few qu Lagi

$250 USD dalam 10 hari
(2 Ulasan)
1.6
dayakmlt

can you share the sample data,,,.........................................................................it require macro coding

$83 USD dalam 5 hari
(1 Ulasan)
1.5
drnagarajesh

A proposal has not yet been provided

$222 USD dalam 3 hari
(0 Ulasan)
0.0
vijayaks

Will give my best based on your requirements. Relevant Skills and Experience I'm know excel macro to interact Web, Excel user form, email draft et.

$200 USD dalam 20 hari
(0 Ulasan)
0.0
rajesh1jangam

A proposal has not yet been provided

$188 USD dalam 3 hari
(0 Ulasan)
0.0
hemantlhs1

I have sound knowledge of Advance Excel, Excel VBA and Macro. I am working in IT Company and working on Excel from last 5 years.

$200 USD dalam 3 hari
(0 Ulasan)
0.0
tiaratechies

Hello, we are a company from India and we are very well experienced in excel and our excel experts are certified by Microsoft Corporation our team can give you the best in shortest time.

$250 USD dalam 2 hari
(0 Ulasan)
0.0
mohamedgouda3

i m a proffisional i excel .. and did a lot of huge projects like this and more .. if you want to see a sample please contact me not only the outpout function you will gain .. a fantastic outpout shape also will gain Lagi

$77 USD dalam 3 hari
(0 Ulasan)
0.0
ebrusikefavour5

A proposal has not yet been provided

$35 USD dalam 7 hari
(0 Ulasan)
0.0
nelumindralal

Hello Sir, Kindly contact me. This job is very similar to my last jobs, I will do perfect match to your requirement Today can start this job I am looking forward to hearing from you Modifications, negoti Lagi

$166 USD dalam 3 hari
(0 Ulasan)
0.0
kushalkuma

Hi, I have over 7 years of experienced in different industries like finance, banking, telecom. I am expert in excel with advanced function and formulas ( VBA, MACRO), MS WORD, MS POWERPOINT. I have 35 wph speed in typi Lagi

$222 USD dalam 7 hari
(0 Ulasan)
0.0
mdsksayed

hi, I am fully skilled nd reay to do this job. thanks.

$35 USD dalam 3 hari
(0 Ulasan)
0.0
ibrahimss1990

I would like to offer you a different solution for your problem. I would like to save you money by suggesting a solution that will cover all your listed needs now and the future needs and problems that you'll eventu Lagi

$250 USD dalam sehari
(0 Ulasan)
0.0
$155 USD dalam 3 hari
(0 Ulasan)
0.0
scorpionobaid01

Hello I am here to assist u inthis project I am an ACCA U.K member currently working in finance dept of Qatar Airways Have great skill and experience in Ms excel and finance Plz share more info to proceed in project. Lagi

$211 USD dalam 5 hari
(0 Ulasan)
0.0
fatimatuzzohura

Hi, I am a highly trained on Excel and VBA. This is something i can do, and i'm thinking in one "big" spreadsheet to manage all aspects (i've done things like that before). Thanks Fatima

$200 USD dalam 3 hari
(0 Ulasan)
0.0