In Progress

Creation of some Excel reports based on multiple Excel sheets

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])

Requirements

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.

Skills: Excel, Data Processing

See more: sum cells multiple sheets excel, sum values multiple sheets excel 2007, lockdown formulas multiple sheets excel, macro vbscript import data multiple sheets excel, summing multiple sheets excel, split data multiple sheets excel, sumif across multiple sheets excel 2010, pivot table from multiple sheets excel 2016, excel - populate multiple sheets based on data entered in a main sheet, excel create list based on multiple criteria, excel vba save multiple sheets as new workbook, excel dynamic list based on multiple criteria, split excel sheet into multiple sheets based on column value, how to copy multiple sheets in excel to new workbook, one sheet to multiple sheets excel, can you create a pivot table from multiple sheets excel 2016, copy and paste into multiple sheets excel

About the Employer:
( 1 review ) Genève, Switzerland

Project ID: #29885759

Awarded to:

merinsinha

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 More

$110 USD in 3 days
(86 Reviews)
5.1

45 freelancers are bidding on average $106 for this job

(409 Reviews)
8.3
P0L

(478 Reviews)
8.0
(304 Reviews)
7.3
(98 Reviews)
5.7
Batairy

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 More

$120 USD in 1 day
(51 Reviews)
5.2
sodiqa32

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 More

$30 USD in 1 day
(7 Reviews)
4.6
(20 Reviews)
4.4
PERPETUAL0

Hello there Ok , created many dashrepotts before I can complete it within short time t Thanks ILyas

$80 USD in 2 days
(39 Reviews)
4.3
AnuradhaVM

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 More

$140 USD in 2 days
(25 Reviews)
4.2
Prgohil89

♦ 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 More

$250 USD in 7 days
(7 Reviews)
3.8
marfan080

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 More

$30 USD in 1 day
(19 Reviews)
3.5
borispetrovfrl

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, More

$90 USD in 2 days
(17 Reviews)
4.0
Muhamadumer141

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 More

$80 USD in 2 days
(3 Reviews)
3.1
mmohsin11

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

$50 USD in 1 day
(1 Review)
2.8
CAAshishy

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

$30 USD in 1 day
(3 Reviews)
1.9
expertewriter

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 More

$140 USD in 7 days
(1 Review)
1.2
mna9226

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 More

$100 USD in 5 days
(2 Reviews)
0.5
higginsotieno

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 More

$70 USD in 1 day
(0 Reviews)
0.0
Noora2742

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 More

$140 USD in 7 days
(0 Reviews)
0.0
aarinmittal032

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 - More

$140 USD in 7 days
(0 Reviews)
0.0