Excel data extraction of aged debtor data

Annulé Publié le il y a 5 ans Paiement à la livraison
Annulé 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.

Saisie de Données Traitement de Données Excel Architecture Logicielle Visual Basic

Nº du projet : #17248430

À propos du projet

53 propositions Projet à distance Actif il y a 5 ans

53 freelances font une offre moyenne de 365 £ pour ce travail

octopus823

Perfect Software Development Languages: C, C++, C#, Java, SQL, JavaScript, Objective C , Swift , Android Databases: MySQL OS: Windows / Linux / MacOS

£555 GBP en 3 jours
(167 Commentaires)
9.0
asin1987

Dear Employer, I understand your requirement. Can we please discuss your job once? I will do it with perfection. Have been creating the Excel automations since ages now. Please give me this opportunity. Thanks Plus

£333 GBP en 10 jours
(227 Commentaires)
7.9
mirniyazuddin92

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

£555 GBP en 10 jours
(423 Commentaires)
8.0
schoudhary1553

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

£722 GBP en 10 jours
(390 Commentaires)
8.1
jared23

Hello, I am an experienced American developer with over 20 years of background in Microsoft product customization, Windows and Web Application Development, and scripting/macros. I believe I will be able to have a vers Plus

£444 GBP en 10 jours
(262 Commentaires)
7.5
zekovicm

Hi there,I am Miljan,Web Scraping expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within Plus

£333 GBP en 3 jours
(176 Commentaires)
7.6
devi222

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(216 Commentaires)
7.0
khushh07

Hello.... Greetings to you !! I have in-dept professional experience and have the ability to provide quality services to my clients. * Ms Excel ( Proficient) ( Pivot table, Charts, Advance formulas, VB Code) Plus

£555 GBP en 10 jours
(280 Commentaires)
7.1
Tanmoy236

"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business Plus

£250 GBP en 10 jours
(267 Commentaires)
7.0
jasminseo6

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

£250 GBP en 2 jours
(114 Commentaires)
6.5
sloker18

I am proficient with excel macro/VBA , I've gone through the attached workbook, I see I can write the macro to perform the extraction as requested, I am available to start your project right away, looking forward to he Plus

£350 GBP en 3 jours
(108 Commentaires)
6.3
pm9887

Hi, I am expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy without adding additional charges. If you are looking for any kind of work, Plus

£388 GBP en 10 jours
(71 Commentaires)
5.8
archanaoswal

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

£250 GBP en 3 jours
(103 Commentaires)
6.1
afenache

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(22 Commentaires)
5.3
Ashisjena2015

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

£250 GBP en 0 jours
(40 Commentaires)
5.3
Itblast

Yes i will surely do Excel data extraction of aged debtor data 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 Plus

£555 GBP en 10 jours
(12 Commentaires)
4.8
dionisiotumbaga

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

£350 GBP en 10 jours
(8 Commentaires)
4.4
serdaryalcin

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

£250 GBP en 10 jours
(21 Commentaires)
4.4
gsanggara

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(28 Commentaires)
4.1
sdroberts

Hello I would love to help you with your date specific debtor query. It is completely possible to calculate totals automatically dependant on two inputted dates (or just one if we're looking at the period since the Plus

£250 GBP en 2 jours
(8 Commentaires)
3.9