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.