OK, I am working on an accounting sheet to keep track of grant-related expenses.
On Sheet 1, I have:
Expense | Grant
Expense is the amount. Grant is the grant it is associated with and chosen from a drop down menu.
So it might look like:
A | B
$500 | Grant 1
$20 | Grant 2
$732 | Grant 1
On...