Build Excel Macro

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

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.

Data Processing Excel Microsoft Access Visual Basic Visual Basic for Apps

Project ID: #17560610

About the project

49 proposals Remote project Active 5 years ago

49 freelancers are bidding on average $188 for this job

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
(945 Reviews)
8.1
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
(376 Reviews)
8.1
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
(223 Reviews)
7.4
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
(313 Reviews)
7.7
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
(411 Reviews)
7.1
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
(92 Reviews)
7.3
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
(272 Reviews)
7.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
(93 Reviews)
6.0
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
(57 Reviews)
6.1
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
(55 Reviews)
6.0
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
(22 Reviews)
5.3
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
(95 Reviews)
5.7
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
(26 Reviews)
5.3
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
(31 Reviews)
4.8
rayyankabir

Hi, I have excellent knowledge on advanced Excel and VBA which you require most. I have 10+ years of experience doing various kind of Excel data model, reporting and analysis. Please give me a chance to showcase my s More

$200 CAD in 4 days
(22 Reviews)
4.9
paulodayto08

Hi, Good Day! I am a PMO Analyst and my primary task is the creation of Financial Reports. I am exposed on different excel formulas and functions. I am also a VBA Macro developer which I think a big plus to compl More

$100 CAD in 2 days
(44 Reviews)
4.7
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
(37 Reviews)
4.8
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
GopalJp

Hi, This is Gopal. I am a book-keeper and accountant. I have gone through your project description and understood. Kindly note that I have been working in Accounting, Tax, Audit and Finance function for more than More

$155 CAD in 3 days
(15 Reviews)
4.6
FirestarterXIII

Hi, I'm IT Engineer with over 10 years professional experience, specialised in Microsoft technologies - Office, .NET and T-SQL. Skills: VB .NET ASP .NET VBA for Excel and Access VBS Microsoft SQL (T-SQL) HT More

$111 CAD in 1 day
(1 Review)
2.4