Excel data extraction of aged debtor data

Anulowany Opublikowano 5 lat temu Płatność przy odbiorze
Anulowany Płatność przy odbiorze

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.

Wprowadzanie danych Przetwarzanie danych Excel Architektura oprogramowania Visual Basic

Numer ID Projektu: #17248430

O projekcie

53 ofert Zdalny projekt Aktywny 5 lat temu

53 freelancerów złożyło ofertę za £365 w tym projekcie

octopus823

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

£555 GBP w ciągu 3 dni
(167 Oceny)
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 Więcej

£333 GBP w ciągu 10 dni
(227 Oceny)
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 w ciągu 10 dni
(423 Oceny)
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 Więcej

£722 GBP w ciągu 10 dni
(390 Oceny)
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 Więcej

£444 GBP w ciągu 10 dni
(262 Oceny)
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 Więcej

£333 GBP w ciągu 3 dni
(176 Oceny)
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.

£300 GBP w ciągu 1 dnia
(216 Oceny)
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) Więcej

£555 GBP w ciągu 10 dni
(280 Oceny)
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 Więcej

£250 GBP w ciągu 10 dni
(267 Oceny)
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 w ciągu 2 dni
(114 Oceny)
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 Więcej

£350 GBP w ciągu 3 dni
(108 Oceny)
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, Więcej

£388 GBP w ciągu 10 dni
(71 Oceny)
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 Więcej

£250 GBP w ciągu 3 dni
(103 Oceny)
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, Więcej

£250 GBP w ciągu 1 dnia
(22 Oceny)
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 Więcej

£250 GBP w ciągu 0 dni
(40 Oceny)
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 Więcej

£555 GBP w ciągu 10 dni
(12 Oceny)
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 w ciągu 10 dni
(8 Oceny)
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 Więcej

£250 GBP w ciągu 10 dni
(21 Oceny)
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 Więcej

£250 GBP w ciągu 1 dnia
(28 Oceny)
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 Więcej

£250 GBP w ciągu 2 dni
(8 Oceny)
3.9