Completed

Excel Project to Update a existing spreadsheet containing some VBA required

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.

Skills: Excel, SQL, Visual Basic, Visual Basic for Apps

See more: putting existing spreadsheet excel, vba project update remaining work, vba excel project beginning, excel vba userform edit record, excel userform search and update, excel vba worksheet change event multiple cells, vba userform to search and edit data, how to update excel worksheet records with userform, add edit delete find vba excel userform only, excel userform add edit delete, how to update data in excel using vba, vba excel import update data, required excel project management trainers bangalore, excel update existing pivot tables connection, rails update existing rails project, access vba excel file update, project update excel sheet, update existing rails project, excel macro update existing tabs data main tab

About the Employer:
( 3 reviews ) Middlewich, United Kingdom

Project ID: #17903243

Awarded to:

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 in 3 days
(4 Reviews)
2.5

11 freelancers are bidding on average £123 for this job

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 More

£200 GBP in 3 days
(278 Reviews)
7.6
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 More

£150 GBP in 3 days
(156 Reviews)
6.4
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 in 3 days
(58 Reviews)
6.2
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 in 3 days
(54 Reviews)
5.5
webanis

Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;

£150 GBP in 3 days
(18 Reviews)
4.1
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 More

£55 GBP in 3 days
(5 Reviews)
3.1
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 More

£50 GBP in 7 days
(1 Review)
0.4
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 More

£51 GBP in 3 days
(0 Reviews)
0.0
Pankajsaini024

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

£150 GBP in 12 days
(0 Reviews)
0.0
evonsystems7

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 More

£208 GBP in 7 days
(0 Reviews)
0.0