Færdiggjort

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

Evner: Programmering af database, Excel, Software Arkitektur, Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Dammam, Saudi Arabia

Projekt ID: #19689222

Tildelt til:

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 ( Flere

$400 USD in 3 dage
(702 bedømmelser)
8.4

36 freelancere byder i gennemsnit $353 på dette 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 Flere

$400 USD in 7 dage
(207 bedømmelser)
8.0
Webxpert4u

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 Flere

$470 USD in 10 dage
(225 bedømmelser)
7.9
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 dage
(291 bedømmelser)
7.2
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 Flere

$400 USD in 5 dage
(79 bedømmelser)
7.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 Flere

$325 USD in 4 dage
(110 bedømmelser)
7.2
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 Flere

$250 USD in 10 dage
(345 bedømmelser)
7.1
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. Flere

$375 USD in 10 dage
(268 bedømmelser)
7.2
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 Flere

$400 USD in 7 dage
(43 bedømmelser)
6.7
shaktistanwar

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 Flere

$382 USD in 10 dage
(46 bedømmelser)
6.5
shoguna2m

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 Flere

$400 USD in 10 dage
(90 bedømmelser)
6.5
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 Flere

$400 USD in 10 dage
(133 bedømmelser)
6.3
SShtv

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 Flere

$350 USD in 7 dage
(79 bedømmelser)
5.9
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 Flere

$400 USD in 7 dage
(47 bedømmelser)
6.0
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 Flere

$280 USD in 9 dage
(15 bedømmelser)
5.5
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 dage
(54 bedømmelser)
5.7
aubrey03

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] Flere

$300 USD in 3 dage
(97 bedømmelser)
5.7
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 Flere

$400 USD in 7 dage
(47 bedømmelser)
5.7
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 Flere

$250 USD in 10 dage
(69 bedømmelser)
5.4
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 Flere

$250 USD in 5 dage
(23 bedømmelser)
4.4
KozlouAlex

Hello. Below are examples of similar work done by me recently: https://www.freelancer.com/projects/excel/Excel-Sheet-devolopment/details https://www.freelancer.com/projects/excel/VBA-within-Excel-Spreadsheet/details Flere

$250 USD in 3 dage
(21 bedømmelser)
4.3