Excel data extraction of aged debtor data
£250-750 GBP
Paiement à la livraison
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.
Nº du projet : #17248430
À propos du projet
53 freelances font une offre moyenne de 365 £ pour ce travail
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 Plus
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 Plus
Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, Plus
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 Plus
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 Plus
Hello, Please find below is my quote for your project #QUOTE# Scope of work : Excel data extractor for aged data Bid Amount : £250 Delivery time : 1 day Note : Yes that can be done thru excel sheet. #UNQUOTE# I am v Plus