I have an excel file containing basically expenses and incomes and need this data to be consolidated (e.g. summed up; divided) in other tabs in particular ways.
a1) if the "Paid by" cell is equal to the "Expense of" cell, account the value in the right category (e.g. Supermarket) of the payer's consolidation tab.
a2) if the "Paid by" cell is different from the "Expense of" cell, consult tab "Sharing of expenses" to see how that particular expense is shared. For instance, the tab "Sharing of expenses" indicates that "Supermarket" expenses should be distributed at the 60-20-20 proportion. So if I register that I expend USD100 in this category, a formula should distribute this value among 3 people: 60 should go to a balance sheet of person A, 20 should go to a balance sheet of person B, and 20 should go to a balance sheet of person C.
b) if a payment is done with a particular credit card, a formula should check the date of the expense and "decide" whether to allocate the expense in the current month or in the next month.
There are other similar rules that must be implemented. Please, estimate your bid based based on the 3 items above only. Values for additional developments can be arranged afterwards.
One challenge is to keep the file not too heavy and slow.
The project will certainly need some "back and forth" between me and the selected provider until we reach the desired results.
Bu iş için 38 freelancer ortalamada $113 teklif veriyor
Excel expert!! I have read the project details thoroughly, and believe to be a perfect fit, for the project.. I will provide unlimited revisions, until we reach the desired results. ZERO ERROR GUARANTEED!! Please read Daha Fazla
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards
Hello, sir! I am happy to put my bid on your project. I have a full of experience with data processing using Excel formula and VBA. Everyone calls me "PRINCESS of Excel". (. ❛ ᴗ ❛.) Here are projects I have done recent Daha Fazla
Hello. My name is Alejandra Baptista I am an accountant, administrator and financial graduated. I am very fast typing and good in redaction or transcription. I have a lot experience with Excel, Power Point, Word, SPSS Daha Fazla
Hi, You need logical formula and best if done through VBA instead of nested formula in excel. I hope that you can discuss me more about this project.
Hi, I've read your description. Those tasks can be done using VBA, and won't be difficult to achieve. I can share you a sample of how it works, if you are satisfied with it, we can go to the next step. Let's have a cha Daha Fazla