I have an Excel workbook that list all my expenses by month (one sheet by month) and by account (one table by account [bank account, credit card, cash]).
I want to summarise and group by Subcategory all the entries from the three accounts (tables [bank account, credit card, cash]) for each month, and also for the whole year. I need four kind of summaries - one for all entries (Bruno, Family, Cassandre), another for Bruno's Group, another for Family's Group, and another for Cassandre Group. I want only the Subcategories that have entries (don't display the Subcategory if there is no entry for this Subcategory)
Plus I want short table with the total for each Subcategory (only the Subcategories that have entries) and the total for all entries (for the concerned Group)
I created something similar using Google Sheets, you can have a look there: [login to view URL] I also attached a screenshot. The only difference in this Google Sheets, it's that all entries come from the same table (there is not a table for each Account [UBS, Mastercard, Cash])
1-Summarise and group by Subcategory all the entries (for Group Bruno, Group Family, Group Cassandre)
2-Summarise the total for each subcategory (only the Subcategories that have entries) and the total for all entries (for the concerned Group)
3-Take the three tables for each month in consideration (UBS, Mastercard, Cash)
4-Be careful, in the file "Bruno's Expenses - 2020", there are some rows used only for autocomplete feature (rows > 100). These rows should not be listed here
5-All empty lines from "Bruno's Expenses - 2020" document should not be listed there. Only rows with relevant info filled (date, debits/credits, recipient, subcategory, category, group) should be listed there.
6-Must be compatible with Excel for Mac
7-Must use index() and match() functions (avoid Pivot Table)
8-Must be dynamic, accept new entries or modification of existent entries and be updated in live
9-Summary tables should be editable, and should retain changes when an entry is added, deleted or modified.
10-The summarise must be refreshed automatically when an entry is added, removed or edited.
I can do it. Hi i am an Senior Excel VBA , Macro formulas Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best Plus
45 freelances font une offre moyenne de 106 $ pour ce travail
I have read your job description and interested to deal with you. My expertise is in the following: 1. Scraping 2. Data Entry 3. Listing of Amazon, Etsy, Ebay 4. MS Word, Excel, Power Point, Google Sheets 5. Web Resea Plus
hello I devour your demand that you’re viewing Creation of some Excel reports based on multiple Excel sheets I provide creative, proactive and high-tech solutions to your development needs. I have solid experience in Plus
Hello there Ok , created many dashrepotts before I can complete it within short time t Thanks ILyas
Hi, Greetings! ✅checked your project details. I can Autocomplete excel feature similar to Google Sheets I have completed the M.SC. (Statistics) . I Have 4 years of experience with Data entry, Data analysis, and MIS Man Plus
♦ Web Research Expert ♦ Previous work available ♦ Team of 18+ ♦ Immediate Start ♦ Offering you Professional IT Experience in data mining, web searching, Web scrapping and lead generation with over 5+ years experience Plus
Hi, I have read your requirements and I am very interested in this project. I have required skills and experience to do this for you at reasonable price. Please feel free to contact me. Regards, Junaid Afsar Graphic D Plus
Hello, Sir. Expert of Excel Report & VBA is here. I've gone through your project requirement and found my skill best suited in this one. I am familiar with technologies such as C++, VB, MS Office, Database Programming, Plus
Hi there, you are now at right place for finding the Person for your project. I have done many projects like this if you want to check samples Drop me a message I am a perfect guy for this project. I have full command Plus
Hey, my team of 25 peoples happy to work on your project... Consider it done as soon as you provide the details we start work on product thanks
We are professionally Qualified Accountant with excellent spreadsheet skills and we adhere to time-line with accuracy. we have the right skills and knowledge to complete this task. regards Ashish
Dear Employer, Do you need someone to execute your job as if you did it by yourself? I am here to help you with any kind of Virtual Assistance. I will love to serve you with my skills and talents. I have 5 years of e Plus
Hello, Please review my profile as I have the relevant skills and experience required for this project. I can start working right now. Kindly send me a message to discuss further for references, portfolio, and case Plus
hello have read the attachment... i have vast experience in administrative work including office suite packages as well as project management and research. i work with precision, efficiently with close attention to det Plus
I'm very much interested in your project. I have great skills and experience in the field of Data processing, Data entry, Excel, Report writing and All other Microsoft offices. I am well organized, details oriented and Plus
I will do data processing for you as well as excel work for you. Just send me your project files and get it converted within your time span. Services, That I offer includes : - Data Entry - Typing - Copy Pasting - Plus