In Progress

Create Excel Macro

We need someone that has the skills to create a Excel Spreadsheet with Macros.

The ideal situation is that when we open the spreadsheet, we click a button to import .CSV file and it will direct the user to select the .CSV file and the it will import that data and arrange it in the way I will provide.

The spreadsheet is called "End of Month Closing Report" and this report will be used for internal business use as we are a serviced office provider:

1. How much we will ne invoicing clients from last month vs this month

2. Top clients by location (who has spent the most this month)

3. A summary of the spend (rent / internet / telephone / services)

Ideal person is a Visual Basic expert with great communications skills.

I have attached a sample of how we envision the final report once data is imported and manipulated.

Cheers,

Helio

Skills: Excel, Visual Basic

See more: macro excel create word, excel create macro vba, create macro excel, macro excel create file, create installer macro excel, create internet macro excel, create print macro excel, excel create html macro

About the Employer:
( 16 reviews ) Berkeley, Australia

Project ID: #11783193

Awarded to:

$250 AUD in 2 days
(248 Reviews)
7.6

78 freelancers are bidding on average $347 for this job

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among More

$400 AUD in 2 days
(362 Reviews)
7.6
maverick44000

Hi, I am highly skilled in Excel and VBA macros and I can develop exactly same attached report from the imported CSV's. I have delivered several similar projects before and I shall be able to finish the job in 3 day More

$400 AUD in 3 days
(81 Reviews)
6.8
seaanddream

Hi, my name is Sevinc. I read your "Create Excel Macro" project descriptions carefully before bidding. I checked the attached template as well... I got what you need and ready to go ahead as soon as we can clarify fu More

$300 AUD in 5 days
(182 Reviews)
7.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More

$350 AUD in 5 days
(141 Reviews)
6.5
aarifakhtar

Hi: I have completed a very similar project in the recent past. https://www.freelancer.com/projects/Excel/Monthly-Report-Creation-need-program/ . Please note that over 90% of my completed projects are related to Excel More

$250 AUD in 3 days
(122 Reviews)
6.6
someka

Hi there. Just checked your doc and project desc. I can be of help on this (csv import with a confirmation box) So that, this csv will be the raw data for your analysis file. Let me know if you are interested. Thanks..

$526 AUD in 5 days
(106 Reviews)
6.7
esalem

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and More

$789 AUD in 15 days
(17 Reviews)
6.4
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 280 projects. Please look at the feedback left by my employers to know more about my work. Wai More

$300 AUD in 10 days
(99 Reviews)
6.2
ineedWorkJob

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert desktop/web software/macro/b More

$500 AUD in 2 days
(98 Reviews)
6.2
shikhamehta

Hello Helio, I reviewed the spreadsheet you shared and would like to inform you that I have created setups that allow users to browse and select a csv and generate the report on click of a button. If you could send More

$300 AUD in 5 days
(90 Reviews)
6.2
P0L

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

$350 AUD in 3 days
(104 Reviews)
6.2
wsh2

Greetings Helio from the USA.. {smile} Highly experienced (25+ years) MsExcel Business System, Programming, and Database expert with Guru / Mentor level technical credentials at www.experts-exchange.com and www.vbci More

$373 AUD in 10 days
(42 Reviews)
6.1
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr More

$300 AUD in 8 days
(95 Reviews)
6.1
MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel projects (with both macros and formulas) and i've never had a single problem. If you are interested send me More

$250 AUD in 3 days
(186 Reviews)
5.8
lukaszoz

Hello, I'm a developer with over 5 years of experience. I work for Pratt and Whitney Canada where i'm responsible for process automation with tools like Access and Excel. I have extensive knowledge regarding C#, VBA More

$250 AUD in 10 days
(24 Reviews)
5.7
zebracaro

i can do it for you quickly and exactly

$277 AUD in 3 days
(78 Reviews)
5.5
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macr More

$250 AUD in 2 days
(57 Reviews)
5.7
gayuh

Hi! I would like to offer my service to create Excel spreadsheet with VBA macro as per your requirements. I have looked at the sample file where you show how you want the final result would be, and I am very conf More

$250 AUD in 5 days
(64 Reviews)
5.6
calebedhouse

Hi, I am a Aussie VB/VB.NET Expert with 20 years experience in professional software development. I have extensive experience importing CSV data, and manipulating it to output similar to your example xlsx workboo More

$500 AUD in 7 days
(6 Reviews)
5.2
macroPOL

Hello, I am Excel and VBA expert. Can I see sample raw data file? Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$333 AUD in 7 days
(52 Reviews)
5.3