Hi,

My 2 workbooks are 1) Company Account and 2 )Project PnL.
This 2 workbook are quite similar. Company account is to moniter m
company in and out going payment. And as for Project PnL is to monite
every project profit or Loss.

1) Company Account consists of:
e.g:

Column A B C
D E F G Date Cheque No
Paid To/ Recieved For/ From $ IN $Out Job No
01-10-04 598561 HDB HUB Permit
200 1
01-10-04 598562 Singtel Phon
Bills 50
01-10-04 598563 Gad Lights BUy LIghts
800 2
01-10-04 - MR Eward Tan Deposit
5000 1


2) Project PnL consists of:
Every Tab sheet is one Job Details, for this case sheet 1 is job 1 an
sheet 2 is job 2 and so on.

Sheet 1
Column A B C
D E F G Date Cheque No
Paid To/ Recieved For/ From $ IN $Out Job No
01-10-04 598561 HDB HUB Permit
200 1
01-10-04 - MR Eward Tan Deposit
5000 1


Sheet 2
Column A B C
D E F G Date Cheque No
Paid To/ Recieved For/ From $ IN $Out Job No
01-10-04 598563 Gad Lights BUy LIghts
800 2

I have been wasting alot of time copying /keying in the same thing fro
company account workbook to Project PnL workbook.
I wonder if there is any functions or formula to filter whatever I ke
in the Company workbook to Project PnL workbook according to the jo
No.

Thank you in advance.
Please I really need this to be solve. Hope someone kind can help.

Mindy On

--
Minde
-----------------------------------------------------------------------
Mindee's Profile: http://www.excelforum.com/member.php...nfo&userid=679
View this thread: http://www.excelforum.com/showthread.php?threadid=26841