Excel data extraction of aged debtor data
£250-750 GBP
Paid on delivery
I currently have a monthly excel sheet that reports aged debtors on a series of date parameters starting at 1m up to 180 days+. I now need to extract the data to report on a new range of dates categories, namely; Current total, 1 month, 2 to 3 months, 4 to 6, 7 to 12 and 12 months and older.
The current sheet has the date the invoice was generated and the amount of the invoice. Is there any way I can automate the process without having to manually filter the dates and add up the totals. What I would like is to be able to input the to and from date range on a separate tab and have the totals for the stated period pulled across from the original data on tab 1. If this could be done on a new line for all of the categories, I could then just copy the info into my summary report. I am open to suggestions.
Project ID: #17248430
About the project
53 freelancers are bidding on average £365 for this job
Perfect Software Development Languages: C, C++, C#, Java, SQL, JavaScript, Objective C , Swift , Android Databases: MySQL OS: Windows / Linux / MacOS
Dear Sir/Ma'am, I can do excel data extraction of aged debtor data. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
Hello, I can help with you in your project Excel data extraction of aged debtor data. I have more than 5 years of experience in Data Entry, Data Processing, Excel, Software Architecture, Visual Basic. We have worked More
Hi Sir, Im expert in excel. I have been working on around 200+ projects regarding excel and Macro's. I can write a macro so that without manual interaction, it will atomate the process to add up.
Hi Dear client, Data Entry expert team here and we will start your work right now and will work with your 100% satisfaction. Regards- Jasmin
I have excellent command on MS Excel. I have gone through the file and understood the requirements. I can automate the process to get the totals for the selected date range. I can even update the summary / invoice auto More
Hi, I CAN HELP YOU RIGHT NOW. I am a Chartered Accountant having more than 10 years experience in accounting and finance. Moreover, I'm also an advanced excel expert. Please discuss in detail over chat as I did similar More
Hi, I would suggest that you store your data in a simple and easy to use MS Access database. I have considerable expertise in the design and development of databases. Regards
Hello, I can write a small macro, that will create several worksheets when run using todays date: Current total, up to 1 month, 2 to 3 months, 4 to 6 months, 7 to 12 months, and 12 months and older. The macro wi More