trying VBA code to get specific data for unique IDs on specific date from date range

Hi every one,

I am trying to write a VBA code from a small set of data to get a "NetAmount" on specific date, let's say, on 25th June 2018, for all "ID"s (unique values). I am attaching the file for your reference.

IDs have transaction history, which are reflected by their repetition. The total number of unique values is 138 and have a start date from 2016-07-17. What could be the best possible way to get those values?

Asset_Liability.xlsm

Roshan Shakya

Thank you very much Kokosek,

The solution is very close but maybe I did not clarify properly in my post. The start date and end date are the dates when the NetAmount was effective, so that means there were effective values on 2018-06-28. Let's take this one instance:

ID start_date end_date asset_value liability_value NetAmount
99ABC3100005005 2018-06-24 2018-06-28 1348409.06 0 -1348409.06

So on 2018-06-25, the effective value of ID 99ABC3100005005 was -1,348,409.06.

Kokosek,

It was an excellent piece of code.

Thank you