Closed

Build Excel Macro

Process daily store sale summary report from text file format into excel database. Based on the excel database stored data, able to search data to analyze sales data by each category by day, by week, by month and generate report and charts. Report need to be intelligent to show where the sales are good and weak. Need report for ordering item based on sales.

Skills: Data Processing, Excel, Microsoft Access, Visual Basic, Visual Basic for Apps

See more: excel macro fill empty cells, excel macro data cell, excel macro cut, how to create a macro in excel 2010, macro excel tutorial, excel macros for dummies, how to create a macro in excel 2013, how to create a macro in excel 2016, use of macros in excel, excel macro examples, macros in excel for beginners, data entry, data processing, excel, visual basic, microsoft, microsoft office, microsoft access, visual basic for apps, microsoft excel

About the Employer:
( 0 reviews ) Canada

Project ID: #17560610

54 freelancers are bidding on average $186 for this job

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

$250 CAD in 3 days
(643 Reviews)
8.3
cgullapalli

HI, I am good at Excel and vba. I have referred the requirements. Please share the excel file with the sales data to analyze it further produce into useful reports. Looking forward to work on the project. -Cha More

$200 CAD in 3 days
(789 Reviews)
7.8
schoudhary1553

Hello, I can help with you in your project Build Excel Macro. I can assure you the quality job as per your expections. I have more than 5 years of experience in Data Processing, Excel, Microsoft Access, Visual Ba More

$200 CAD in 3 days
(293 Reviews)
7.7
deepbluetech

Hi, I am an Excel macro expert with more than 10 years of experience. Kindly share further details and we can discuss. Regards, Arul

$250 CAD in 3 days
(219 Reviews)
7.3
paris2785

Hello! My name is Paris Pallas and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I wo More

$200 CAD in 7 days
(203 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. Best regards

$200 CAD in 5 days
(215 Reviews)
6.8
fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus on user friendly interface. As More

$35 CAD in 3 days
(89 Reviews)
7.4
TonmoyRoy111

Dear Client, I can build the macro for you. Also the dashboard you are looking for. I have vast experience in excel and have already done lots of projects. Please contact me. Roy

$200 CAD in 3 days
(271 Reviews)
6.5
zu02

Hi I understood your task. I placed here my bid to make it for 750 cad and it will be a proper price if you really want to have a very useful and simply for using software - I can code that via Excel or via Acces More

$833 CAD in 7 days
(51 Reviews)
6.1
abhinovpankaj

Hello, I have been working as freelancer since last ~ 6 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat More

$177 CAD in 3 days
(65 Reviews)
5.6
SShtv

I have a lot of practical experience in Excel. Including the development of databases and User Forms. Your task is clear to me and I am ready to execute the project for the 150 CAD. These are screenshots of some of m More

$150 CAD in 3 days
(62 Reviews)
5.7
satishtl

- Based on the daily sales volume details the data can be imported into Excel databse. - Reports can be generated based on the grouping Store, Category, Item across stores giving the visual representation using chart More

$160 CAD in 4 days
(53 Reviews)
6.1
archanaoswal

I have excellent command on MS Excel and can create a report as per your requirements. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place More

$180 CAD in 3 days
(77 Reviews)
5.8
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes More

$250 CAD in 3 days
(69 Reviews)
5.3
crypthne

I'm an experience MS Excel and vba developer, have been in this field for almost 10 years and working many MS Excelor MS Access related project. I'm also Brainbench MS Access certified. I'm confidence I can finish this More

$166 CAD in 3 days
(35 Reviews)
4.7
jasalaz100

Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizi More

$250 CAD in 7 days
(27 Reviews)
4.8
$100 CAD in 1 day
(41 Reviews)
5.2
VBAautomation

Hi, After having a look on your requirements I would like suggest you to a MS Access database. Why MS Access: 2gb of data storage with smooth and fast functionalities. Multiple user enabled keep your backend in a n More

$444 CAD in 5 days
(14 Reviews)
4.5
serdaryalcin

Hi, I have completed a very similar project for an Australian company at the past. They did have weekly data for the products sold in the stores. My macro creates graphs using the data to compare a date range wit More

$250 CAD in 10 days
(21 Reviews)
4.4
afenache

Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, More

$230 CAD in 5 days
(11 Reviews)
3.9