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 freelancers are bidding on average £123 for this job
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.