Create simple Excel VBA to summarise sales data

$10-30 AUD

Completed

Posted

over 4 years ago

$10-30 AUD

Paid on delivery

We just need a tool to summarise sales data that is output from our point of sales system. The data from 2 days is attached. Also an output template is provided (with dummy data) For each till we need First sale of each staff, last sale of each staff Total Cash sales (where payment type is cash) per staff per till Total Cash sales per till Total Other sales per till (visa, master, etc, and include rounding) Subtotal per till Then total cash for all tills Total other for all tills And grand total. The tool should be a VBA workbook, and have a landing page where the user selects the file they want summarised. It should then summarise it, and then ask the user where to save the output. The file name of the output should be YYYY-MM-DD-sales-summary.

Excel

Visual Basic

Project ID: 22291481

About the project

4 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@Ahmed818

Hello, ⭐⭐⭐⭐⭐ i am expert in this kind of jobs samples of my excel VBA jobs ⭐⭐⭐⭐⭐ https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ https://www.freelancer.com/projects/Data-Entry/Capture-data-from-website-website-12641885/ ⭐⭐⭐⭐⭐ waiting your answer Regards

$30 AUD in 1 day

4.9

(63 reviews)

4.7

4 freelancers are bidding on average $28 AUD for this job

@akritisood94

I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main Skills: - Excel - VBA - Python - Web Scraping - MS Office Word, Outlook, Access, PPT Skill Set in Detail: - Office & Web Automation & Blogging on Office Tricks & tips. - Python Programming, Web Scraping - Data Scraping - Manual to Automatic updates in Excel - Excel Pivot Charts & Tables - Excel Auto Filter, Vlookup, Formula Assistance - Excel to Access - User Forms in Excel - Calendars in Excel - Bulk Files Processing in side a Folder - Folder Operations - Sending Email from Excel - Extract Data from Webpages Requesting to Contact before ordering. This would enable me to give a feasible custom offer. Please drop a message once you feel comfortable with my profile & lets get started with a feasible amount. Thanks for your time

$30 AUD in 7 days