Automate my Excel workbook using VBA and Macros

My name is Thomas. I work for a small technical college. I have designed a workbook that our organisation will use to record customer feedback and generate analytics (graphs and charts) using data from that feedback. I need someone to automate this workbook, and help me make it into a simple process which can be used by a novice. Details are given in the "Task Summary" file and the Excel document (with comments) attached.

In brief, I need the workbook to do the following:

1. Essential: Data input to a Customer Feedback Sheet must automatically populate to the Data Sheet.

2. Essential: The graphs and charts on the Analytics Sheet must automatically update in reponse to new data in the Data Sheet.

3. Essential: All Customer Feedback Sheets will be saved so they can be accessed using the tabs at the bottom of the workbook. Each time a new Customer Feedback Sheet is created, the Data Sheet must recognise this and automatically allocate it a new line on the Data Sheet.

4. If possible: Customer Feedback Sheets must be completed within a specific timeframe. If the sheet has/hasn't been completed within this timeframe, this must be reflected in the Data Sheet.

I will need full permissions to review the code etc. in the final document. It's important that I'm not locked out of anything in case our IT department need to make changes in the future.

Timeframe- end of month

Skills: Database Programming, Excel, Software Architecture, Visual Basic

See more: microsoft excel automation, 2500 excel vba examples free download, vba excel examples, excel macro tutorial pdf, excel vba, how to use macros in excel, excel macros, macros in excel for beginners, data excel workbook master workbook using vba, export data webpage excel sheet using vba, extract image excel using vba, import dat file using vba excel, uninstall addins excel using vba, import mpp file excel using vba, install excel add using vba, transfer data excel word using vba, vbaexcel connecting excel access using vba private, sheet name excel workbook using vbscript, display data values excel chart using vba macros, excel workbook word vba macro

About the Employer:
( 0 reviews ) Dammam, Saudi Arabia

Project ID: #19689222

Awarded to:


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( More

$400 USD in 3 days
(702 Reviews)

36 freelancers are bidding on average $353 for this job


Hello, I am Excel Expert and VBA Developer who can help to automate every process necessary for your workbook Also, I can provide full documented source code with explanations why we did what we did and with what metho More

$400 USD in 7 days
(207 Reviews)

Thomas! I am ready to automate your sheet to make things easier. Please send me message so we can discuss and can clear all things before starting. Highly experienced in Excel Programming, Excel automation and Macro More

$470 USD in 10 days
(225 Reviews)

Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$400 USD in 5 days
(291 Reviews)

I can suggest to you a module in Microsoft Excel which enables to upload and/or add/update records on flexible bulletin forms. Excel validates and manipulates the information (add formulas), and keep the form in the m More

$400 USD in 5 days
(79 Reviews)

Hi there,I am Excel VBA/Macros expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within More

$325 USD in 4 days
(110 Reviews)

Hello Sir Im excel VBA macro and formula Expert :) i can do make your existing macro design will easy to use Sir :) i already check your task summary pdf file and your existing macro design dot xlsm file please pin More

$250 USD in 10 days
(345 Reviews)

Hey, Can you send a message to me over chat? I would then be able to share samples from a couple of dashboards that work on almost same requirements as yours. That should give you an idea on the quality I can deliver. More

$375 USD in 10 days
(268 Reviews)

Hello. I have 8+ years experience in development using python, c/c++, c#, java etc. Especially I have rich experience in VBA, Macro and online data management in Excel I can show my previous work if you want. I am 100 More

$400 USD in 7 days
(43 Reviews)

HI Thomas, I am a technical evangelist, developer and can do this task for you. I have more than 15 years of experience in software development and am a microsoft certified professional.I have strong work experience i More

$382 USD in 10 days
(46 Reviews)

Hello Thomas, my name is Andres. I have developed several similar tools during the last years for companies and even for my own company, using Excel. I have high-level skills using the software and automatizing process More

$400 USD in 10 days
(90 Reviews)

I am Fatima a full time PREFERRED FREELANCER and have profound knowledge on Excel. Before we start the project would like to have a detailed conversation with you regarding this project to see where we can fit in. I a More

$400 USD in 10 days
(133 Reviews)

Hello, I'm interested in your proposal. Your task is clear to me and I am ready to solve it. I have a large and successful hands-on experience in processing and analyzing data in Excel, as well as visualizing the data More

$350 USD in 7 days
(79 Reviews)

Hello, If you are looking for an automation expert that is having 15 years of experience in sales, I would like to work on this project, spare a minute to discuss the scope of work. Note: I've already used similar conc More

$400 USD in 7 days
(47 Reviews)

Hi First of all - all You describe is mostly better done in Google Sheet + Google Forms + Google Script If You want i can prepare and automatize all that for You What do You think? Im good in it all If using Excel is s More

$280 USD in 9 days
(15 Reviews)

Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry, excel

$361 USD in 5 days
(54 Reviews)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$300 USD in 3 days
(97 Reviews)

Hi Thomas, I have read your brief & visited all your attachments, and I gather that you require to automate the customer feedback process and to have dashboard (auto update). I am a professional freelancer having adva More

$400 USD in 7 days
(47 Reviews)

Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully and saw attached documents. I can develop vba program as per your requirements - 1. Essential: I w More

$250 USD in 10 days
(69 Reviews)

I am postgraduate (MBA) in finance with more than 5 years of experience in financial modeling, advanced excel, VBA/Macro automation and data processing. I have previously worked for many reputed companies like E&Y, EX More

$250 USD in 5 days
(23 Reviews)

Hello. Below are examples of similar work done by me recently: More

$250 USD in 3 days
(21 Reviews)