Find previous day balance.

[Pamella]

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.

[Bob Phillips]

That statement raises so many questions I cannot even begin.

What are you trying to do, in overall terms?

[Paul_Hossler]

And an example workbook would be helpful also