Automate my Excel workbook using VBA and Macros

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

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

Database Programming Excel Software Architecture Visual Basic

Project ID: #19689222

About the project

33 proposals Remote project Active 4 years ago

Awarded to:

jaylancer43

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 freelancer.com and have been featured by the freelancer community ( More

$400 USD in 3 days
(858 Reviews)
9.0

33 freelancers are bidding on average $357 for this job

sandroshubladze

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
(162 Reviews)
8.2
P0L

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
(487 Reviews)
8.0
zekovicm

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
(188 Reviews)
8.0
tiaratechies

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
(108 Reviews)
7.6
trascenderglobal

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
(175 Reviews)
7.8
prameswara

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
(411 Reviews)
7.6
DevStar925

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
(59 Reviews)
7.3
fatimatuzzohura

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
(199 Reviews)
7.3
shikhamehta

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
(233 Reviews)
7.3
dgled

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
(95 Reviews)
7.5
KavTan

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
(53 Reviews)
6.3
razvancotofana

Hello Thomas, After reading your project details my approach will be slightly different, namely I'll use VBA forms to do the CFL/SFL records. Inputs will be then fed directly into Data Sheet and Analytics. We can discu More

$250 USD in 3 days
(19 Reviews)
6.1
bhupendrayadav

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
(50 Reviews)
5.9
vsprybhanu

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
(128 Reviews)
6.1
sonarkaushik

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
(55 Reviews)
5.8
romanapanovich

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)
5.5
alexandersolomon

My Name is Alexander, by profession I am a VBA developer, I have extensive experience on designing, analyzing, developing and automating different processes using VBA. I am RPA UiPath certified professional. With 5+ y More

$250 USD in 3 days
(0 Reviews)
0.0
Riz31

Dear Employer, Please allow me to offer you my services. I am an engineer with more than 16 years of a very diversified experience profile in the fields of ICT, Telecom, management, consulti More

$361 USD in 10 days
(0 Reviews)
0.0
kakkarak1960

Hi, As per reading your description and your requirements, I am offering you that I can provide excel management in accordance with all the requirements which you need. The creation and management part comes with all More

$300 USD in 7 days
(1 Review)
0.0
terinao86

hape i can help,DM for detail

$361 USD in 10 days
(0 Reviews)
0.0