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.
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.
11 freelance font une offre moyenne de £123 pour ce travail
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 Plus
"""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 Plus
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
Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;
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 Plus
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 Plus
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 Plus
I am perfect in excel word and outlook Relevant Skills and Experience I will do perfect work
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Plus