Excel Project to Update a existing spreadsheet containing some VBA required

Ολοκληρωμένο Αναρτήθηκε Πριν 5 χρόνια Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

Looking for an Excel expert to create a spreadsheet for entering parts onto our ERP System. The purpose of the spreadsheet is it will capture all the required fields to be entered and perform some basic error proofing, such that we can see that all departments have entered the relevant data.

The spreadsheet exists and pulls some basic information from SQL for error proofing and selecting correct options.

We have a first version of this spreadsheet but need to add the following functionality

1. Structure the document to remove some confusion on instructions sheet, moving the SQL extract to different tabs

2. Add drop down menus for each column for who is responsible for that column in the instructions tab

3. Add a workings tab which groups the responsible together based upon instructions tab

4. Add a summary tab of which department needs to fill in their actions.

5. Ensure correct Drop downs work in Workings tab looking up SQL extract tabs

6. Automatic colour coding of headers based on responsible selections from instructions tab.

7. Add a tab for a check list of items which we can edit, which has Action , Who , Date, Complete. Have Functionality to RED , AMBER , GREEN based upon RED Late, Amber Incomplete. Green Complete.

Excel SQL Visual Basic Visual Basic για Εφαρμογές

Ταυτότητα Εργασίας: #17903243

Σχετικά με την εργασία

9 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 5 χρόνια

Ανατέθηκε στον:

dalsaniyasonu123

Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.

£44 GBP σε 3 μέρες
(44 Αξιολογήσεις)
5.1

9 freelancers κάνουν προσφορές κατά μέσο όρο £111 για αυτή τη δουλειά

schoudhary1553

This is Vibrant Webtech and I was glad to see that you're looking for help for project Excel Project to Update a existing spreadsheet containing some VBA required. I've delivered more than 400 + projects in the last Περισσότερα

£200 GBP σε 3 μέρες
(343 Αξιολογήσεις)
8.0
Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m Περισσότερα

£150 GBP σε 3 μέρες
(251 Αξιολογήσεις)
6.9
polarjin2017

Hello? How are you? I have good skills in excel vba....... So I think we can work together. Hope to work with you. Thank you. I have done so much jobs in this fields.

£133 GBP σε 3 μέρες
(103 Αξιολογήσεις)
6.7
rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

£166 GBP σε 3 μέρες
(101 Αξιολογήσεις)
6.2
akritisood94

I can assure you that I will be able to submit your task in time with quality work. I have already completed so many projects. Please have a look on my portfolio and profile. I have listed many successful projects in m Περισσότερα

£55 GBP σε 3 μέρες
(32 Αξιολογήσεις)
4.4
kumarapush777

I will be able to do this Excel Formating, Drop down adding. Color coding & Reporting. If selected pls share the Excel Template. I have 15 yrs Experience in Excel Macro, VBA, Word & Office Automation. Please visit Περισσότερα

£50 GBP σε 7 μέρες
(14 Αξιολογήσεις)
3.3
skourav07

Hello there I would like to assist you in this project i am good in excel work give me a chance to complete this project i will make you happy in this project i am hard working person and i will do my best work fo Περισσότερα

£51 GBP σε 3 μέρες
(0 Αξιολογήσεις)
0.0
Pankajsaini024

I am perfect in excel word and outlook Relevant Skills and Experience I will do perfect work

£150 GBP σε 12 μέρες
(0 Αξιολογήσεις)
0.0