Create simple Excel VBA to summarise sales data

$10-30 AUD

I përfunduar

Postuar

over 4 years ago

$10-30 AUD

Paguhet në dorëzim

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

ID e Projektit: 22291481

Rreth projektit

4 propozime

Projekt në distancë

Aktive 4 yrs ago

Po kërkoni të fitoni para?

Adresa e email-it

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj

Paguhuni për punën tuaj

Përshkruani propozimin tuaj

Është falas të regjistrohesh dhe të bësh oferta për punë

I dhënë për:

@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 në 1 ditë

4,9

(63 përshtypje)

4,7

4 profesionistët e pavarur ofrojnë mesatarisht $28 AUD oferta për këtë punë

@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 në 7 ditë