Find previous day balance.

Look in columnA last populated cell to find current date. If found look back up in ColumnA to find previous date. If found...go to Column G. Col G must Must have heading as "Balance". Get the Balance. Get Currency from column D. Again ensure heading is Currency.

That statement raises so many questions I cannot even begin.

What are you trying to do, in overall terms?

And an example workbook would be helpful also