Hi All,
I was wondering if anyone could tell me how to get round this problem, hopefully my description of what i am trying to do shall make sense.
I have a sheet listing a number of transactions on various 'cost centres', i then have a further sheet for each cost centre that needs to take the information from the transaction sheet and just pull out the relevant ones for that cost centre. At the moment i go through manually and do the old copy and paste scenario. Does anyone know how i can get excel to do this electronically for me at a click of a button?
This is an example of what i have on my transaction sheet:
CC Value Description
5AYA 200.00 Payment to Company A
5AYA 100.00 Payment to Compan C
5AYB 700.00 Payment to Company A
5AYB 990.00 Payment to Compan C
5AYC 125.00 Payment to Company A
Then i have a further sheet for example for cc 5AYA
Transactions for 5AYA
CC Value Description
5AYA 200.00 Payment to Company A
5AYA 100.00 Payment to Compan C
How can i get Excel to automatically pull this information off the first sheet for me? I have had a look through all the formulas and functions, however i can't find anything, or i'm overlooking it...
Thanks,
Paul
I was wondering if anyone could tell me how to get round this problem, hopefully my description of what i am trying to do shall make sense.
I have a sheet listing a number of transactions on various 'cost centres', i then have a further sheet for each cost centre that needs to take the information from the transaction sheet and just pull out the relevant ones for that cost centre. At the moment i go through manually and do the old copy and paste scenario. Does anyone know how i can get excel to do this electronically for me at a click of a button?
This is an example of what i have on my transaction sheet:
CC Value Description
5AYA 200.00 Payment to Company A
5AYA 100.00 Payment to Compan C
5AYB 700.00 Payment to Company A
5AYB 990.00 Payment to Compan C
5AYC 125.00 Payment to Company A
Then i have a further sheet for example for cc 5AYA
Transactions for 5AYA
CC Value Description
5AYA 200.00 Payment to Company A
5AYA 100.00 Payment to Compan C
How can i get Excel to automatically pull this information off the first sheet for me? I have had a look through all the formulas and functions, however i can't find anything, or i'm overlooking it...
Thanks,
Paul