Hi All,

I have 7 different bank accounts that I manage everyday, which I have 7
different workbooks that I enter data for. Once I fill out all of the detail
for each bank account for that day, I then have to go to a "Consolidated"
Cash sheet, and re-enter the data for the day so that each of my "detailed"
bank account files equals to my summary cash file.

I would like to be able to enter the detailed data in each of the individual
workbooks, and have the information automatically updated when I open the
consolidated workbook. This would save hours!!!!!!

I have given this some thought, and so far, here is what I have come up with.

For each detailed workbook, I have two columns that would be pertinant to
"coding" for the consolidated workbook. For example, column B would have
sub account validation box with 3 choices, F-01-BS,M-01-BS,and U-01-BS.
Column C would have multiple choices such as A/P, Billing Receipt, LOC
Advance, Other.

For the consolidated workbook, I would want to this to be executed "look
into 1100 Cash.xls, and for every F-01-BS that is a "billing receipt", then
return the data in column G here". (Column G would be the numeric amount for
this transaction) This, unfortunately is where I get hung up...I am not sure
how the formula should read for this to happen.

Any help would be greatly appreciated...thanks in advance....sorry for the
long post