I have created an expense report using to sheets. The first sheet has the
weekly expenses broke down by type of expense. The second sheet has the
expense broke down as you would see in your bank statement (date, vendor,
debit or credit and running total).
How do I add a type column on the second sheet (drop down list) that will
use the types from sheet one? I want to even take it further and use the type
on sheet 2 to pull the debit or credit (on sheet 2) and apply it to sheet 1
in the correct type line. Making it more complicated is that I am tracking
two accounts on sheet 2 and therfore have 2 columns of debit & credits.

Any suggestions would be appreciated.