dear all:

I have a big problem but can't solve it. I posted and asked for lots of examples and helps but still can't get over with it.. Now i'll post the problem here. Hope that u can help me. Lots of thanks...

there are 4 excel workbooks (eg: A,B,C,D) which contains lots of project records, together with other related info such as developement name, developement area, date start/completed, status and etc.

i want to do a search in VB to search a particular project info among the 4 workbooks based on the project ID. The project ID is unique so i can get the result i want. THen the VB will open the workbook which contain the data that i want, for example, i search for project P001. P001 is inside workbook B. Vb will open workbook B, and highlight the entire row of project P001.

The search also can based on the project area. For example, i want to search for project in area_A, VB will retrieve all the project that under area_A in 4 workbooks A,B,C,D, then it generates a new workbook called 'result.xls' to display all the project under area_A with the format just like workbook A,B,C,D.

This program can also direct-link to those 4 workbooks. There are 4 buttons(A,B,C,D) which, when clicked, will open the respective workbooks.

I know this might seem easy for u all....but i'm new in VBA and this is my 1st project...Can someone help me with this? THanks so much....