I'm setting up a spreadsheet that will allow inputs from 15 bank accounts to be consolidated to produce details of the ACTUAL cash flows of the organisation i work for.
In sheet 1 my idea is to have an "database" type arrangement with the following columns;
A : Date
B: Category of Income/Expenditure
C : Value (£)
D : Bank account (any 1 of 15 !)
The second sheet will have dates along row 1.
Column A will contain the different categories of Income and expenditure.
I need the calculation to be if date in Sheet 2 , row 1 = date in column B , Sheet 1.....look up the income/expend category (ie Col A , SHEET 2 TO COL B , Sheet 1)..and put £ value.
If that makes any sense whatsover !
Thanks in advance :wink:
Will M
In sheet 1 my idea is to have an "database" type arrangement with the following columns;
A : Date
B: Category of Income/Expenditure
C : Value (£)
D : Bank account (any 1 of 15 !)
The second sheet will have dates along row 1.
Column A will contain the different categories of Income and expenditure.
I need the calculation to be if date in Sheet 2 , row 1 = date in column B , Sheet 1.....look up the income/expend category (ie Col A , SHEET 2 TO COL B , Sheet 1)..and put £ value.
If that makes any sense whatsover !
Thanks in advance :wink:
Will M