Automate my Excel workbook using VBA and Macros

$250-400 USD

Opravljeno

Objavljeno

pred skoraj 5 leti

$250-400 USD

Plačilo ob dostavi

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

ID projekta: 19689222

Več o projektu

33 ponudb

Projekt na daljavo

Aktivno pred 5 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@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 ([login to view URL]). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. Please pay me once the job is 100% complete. Also I will provide you with a sample work before you consider awarding me the project. Please initiate a chat so we can discuss on this as I may have some questions. Thanks, Jay

$400 USD v 3 dneh

5,0

(858 ocen)

9,0

33 freelancerjev je oddalo ponudbo s povprečno vrednostjo $357 USD za to delo

@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 methods etc etc If you will be interested, contact me Thanks & Regards

$400 USD v 7 dneh

4,9

(162 ocen)

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 v 5 dneh

5,0

(487 ocen)

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 the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan

$325 USD v 4 dneh

4,9

(188 ocen)

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 concepts on multiple projects and I can be a valuable asset on this project.

$400 USD v 7 dneh

5,0

(108 ocen)

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 processes through macros and VBA. Would be great to work with you on this as my preferred work involves to give people and organizations tools that allow to improve and enhance their daily work. Thanks for considering me, looking forward to talking with you via chat to discuss the details. Have a good day!

$400 USD v 10 dneh

4,9

(175 ocen)

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 ping me now and im able to discuss now and after that im able to fnish this job within your time frame end of this month :) Thank you Galih

$250 USD v 10 dneh

4,9

(411 ocen)

7,6

@DevStar925

Zastava LAO PEOPLE'S DEMOCRATIC REPUBLIC

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% sure I can satisfy your requirements and if you hire me, I will provide you good results. I want to discuss more in detail with you. Best Regards.

$400 USD v 7 dneh

4,9

(59 ocen)

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 am a highly trained on Excel and VB Macros. I did many projects regarding automated yahoo finance/forex stock update dashboard . I did many project related to KPI template using MS Excel.

$400 USD v 10 dneh

4,9

(199 ocen)

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. I am an expert in Excel and have reviewed the files you shared. I can certainly create the dashboard as desired. Let us chat and get started on the project right away. Best Regards, Rishi

$375 USD v 10 dneh

4,9

(233 ocen)

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 main database. Also, Excel populates template reports and documents based on the needed parameters and criteria. There is a report generator which enables to develop templates independently. Also, There is a search engine with high search capability to find specific information and the files are secured by username login and password. I am an expert and guru in Financial, Math and Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. I am sure that my combined knowledge, skills and creativity will lead to exceptional results that will exceed your expectations.

$400 USD v 5 dneh

4,9

(95 ocen)

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 advance skills in MS Excel and have created several dashboards for my clients. You may visit my portfolio page to see the sample work and to assess the quality of services I render. I request you to get me on the freelancer chat to discuss this further along with deliverable. Thank you for the opportunity.

$400 USD v 7 dneh

4,9

(53 ocen)

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 discuss rest of the outputs you need to get but I'd definitely like to help you with your project if I can. BR, Razvan

$250 USD v 3 dneh

5,0

(19 ocen)

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, EXL Services, and CRISIL Ratings, I have successfully completed similar projects. Please have a look at my portfolio for more details. I have developed financial models for Ernst and Young also. You can get your work done here with highest quality at lowest price. I can do this project in $220 USD Please feel free to contact me in case of any query

$250 USD v 5 dneh

4,9

(50 ocen)

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 will program to populate Data Sheet according to data input to customer feedback sheet 2. Essential: Program will automatically update the graphs and charts on the Analytics Sheet in reponse to new data in the Data Sheet. 3. Essential: All Customer Feedback Sheets will be saved. New data will be entered on new line of data sheet. 4. It is possible You will have full permissions to review the code. I have done mostly Excel VBA Programming jobs. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra

$250 USD v 10 dneh

4,8

(128 ocen)

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 v 5 dneh

4,6

(55 ocen)

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 so important we can discuss also this task in Excel but i strogly recommend using Google service instead. P.S. After we will discuss it Ill need first 60$ milestone to start working P.S.2 also we can research possibility of web-based solution but i think it isnt very well for Your scope

$280 USD v 9 dneh

5,0

(15 ocen)

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+ years of rich experience in Automating, developing maintaining and upgrading VBA applications, as well as reverse engineer current macros by debugging and stepping through code. I have good experience in designing SharePoint site using HTML, Asp.net, Css, JavaScript in SharePoint designer application and well versed with SharePoint workflows, data retention policy. Also, excel in integrating various applications on excel using VBA, like: Gmail, SharePoint list, SQL, Access, Word, Outlook, PDF, Text, web using XML, webpage using HTTP etc. . As a highly analytic and organized individual, I can proactively clarify and question business requirements, in relation to system capabilities. Moreover, these skills help me in effectively analyzing and converting business requirements to develop VB applications, and perform well-placed object oriented designing and analysis. Owing to the fact that I am a diligent individual, I can perform testing work in an exceptional manner, aiming for optimal performance. I will be happy to connect with you and work on your automation projects

$250 USD v 3 dneh

0,0

(0 ocen)

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, consulting and freelancing. I have been working on long terms basis with a number of successful clients. I can share my work samples with you for your reference and consideration. Data is my strong area and I have hands on working on a number of platforms for the same. We can discuss this further if you deem suitable. BR Rizwan Younis

$361 USD v 10 dneh

0,0

(0 ocen)

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 the calculation and writing techniques. So, if you would like to work with us or want to know how we will provide you with the work, let’s have a quick chat over this. Message us in the box. Meanwhile, you can check our work portfolios below. You can contact us for no. of financial services as listed below: • Accounting • Financial Management • Contracts Preparation We have all the expertise and practical knowledge over the sector of finance, accounting, contracts creation (development & designing), management solutions, accounting solutions and much more delivering only gratifying results. And also if you would like to discuss over this, you can message us in the inbox and have a quick chat.

$300 USD v 7 dneh