Excel Project to Update a existing spreadsheet containing some VBA required
£20-250 GBP
Πληρώθηκε κατά την παράδοση
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.
Ταυτότητα Εργασίας: #17903243
Σχετικά με την εργασία
Ανατέθηκε στον:
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.
9 freelancers κάνουν προσφορές κατά μέσο όρο £111 για αυτή τη δουλειά
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 Περισσότερα
"""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 Περισσότερα
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.
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
I am perfect in excel word and outlook Relevant Skills and Experience I will do perfect work