Automate my Excel workbook using VBA and Macros
$250-400 USD
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
Project ID: #19689222
About the project
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 freelancer.com and have been featured by the freelancer community ( More
33 freelancers are bidding on average $357 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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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