SoullessToaster
New Member
- Joined
- Jan 10, 2014
- Messages
- 17
Working on an accounting spreadsheet, and i have the boss breathing down my neck to get this one finished, however i need some help with a formula.
I have got a worksheet called "I&E" (Income and expenditure) which lists all financials coming into and out of the company and charged to the company charge card.
I have created some new sheets in which i want the same information but filtered in such a way as to isolate different types of payment methods. For example, a sheet for JUST mastercard payments, a sheet for bank account payments, a sheet for cash payments in etc.
I know i can just use filtering to influence the main sheet, but i don't want to do that. I have different formulas that need to be carried out on the different sheets, so therefore need the other worksheets.
The formula that i need, for the bank account one for example, i thought should look something along the lines of
=IF'i&e'!$E:$E"Bank Transfer"OR"Direct Debit"OR"Cheque"OR"Cash Withdrawal"
Then i want it to populate column A with the contents of column A from I&E if column E matches the above criteria.
Same for column B
C
D
E
F
and
G
Hopefully you guys understand what i'm after, i'm really struggling here.
When i started this spreadsheet i though "How hard could it be?"
Famous Last Words
I have got a worksheet called "I&E" (Income and expenditure) which lists all financials coming into and out of the company and charged to the company charge card.
I have created some new sheets in which i want the same information but filtered in such a way as to isolate different types of payment methods. For example, a sheet for JUST mastercard payments, a sheet for bank account payments, a sheet for cash payments in etc.
I know i can just use filtering to influence the main sheet, but i don't want to do that. I have different formulas that need to be carried out on the different sheets, so therefore need the other worksheets.
The formula that i need, for the bank account one for example, i thought should look something along the lines of
=IF'i&e'!$E:$E"Bank Transfer"OR"Direct Debit"OR"Cheque"OR"Cash Withdrawal"
Then i want it to populate column A with the contents of column A from I&E if column E matches the above criteria.
Same for column B
C
D
E
F
and
G
Hopefully you guys understand what i'm after, i'm really struggling here.
When i started this spreadsheet i though "How hard could it be?"
Famous Last Words