Angel.pie001
New Member
- Joined
- Jun 25, 2012
- Messages
- 14
I was wondering if somebody could help over this
sheet1
A-----B
1)------01/07/12
50----canteen
80----bank
2)------02/07/12
70-----bank
30-----misc exp
3)------03/07/11
20------canteen
20------misc exp
So now what i need is excel to evalutae the canteen account from column"B"
And feed into another excel sheet by himself
for example
Sheet2(i will call it as a canteen account)
A----B
50----01/07/2012
20----03/072012
I mean execl to find the word canteen from column B,if found then match a value from column A, and feed it into another sheet with the date above it.
likewise i want to create a monthly so there will be arround 30 possibilities of this account appearing.
Thank you
help please