VBA code to find last entry on a certain date and bring back the text in the adjacent

[pedros23]

Hi,

I hope I'm making sense here.

I have a spreadsheet with hundreds of sheets on it (one for each of my customers)

Basically they each have an amount of money from which they can order goods from me. I need to be able to find out the balance of each fund on any given date in the past and wondered if there is a VBA code that create a summary sheet.

There could be several entries for the same date, but at the same time there may be no entries for that date, therefore I need it to search for either the last entry on the date requested or the next date before this with an entry.

I have attached an example speadsheet.

Many thanks in advance.