PDA

View Full Version : Solved: Help in handling excel sheets with data



alphonse_joe
01-24-2008, 09:36 AM
Hello!
Please can anyone help me with my project in excel. I can do this manually, however after going through this forum , I feel that this can be done using Macros.
I have two tables, Table-A and Table-B with column headers as- A- Name, B- amount, C- date and so on.
Since these tables contain so many rows and columns I need help to identify and seperate the complete row containing names that are common in both tables and complete rows containing names that are not common in both tables.
The result is to be in seperate tab named " rows common -Table-A" , rows common -Table-B, "rows unique -Table -A" and lastly "rows unique - Table-B"
Any help on the above will be much appreciated.

Thanks


Alphonse

alphonse_joe
01-24-2008, 11:34 AM
Is this possible to acheive?

Alphonse.

alphonse_joe
01-24-2008, 01:00 PM
Can anyone tell me on how to post attachments in the forum please.
I would like to post a sample extract from my database so that it is easier to understand.

Thank you

Alphonse

alphonse_joe
01-26-2008, 06:55 AM
Well , I have solved this myself. It is amazing since about 40 persons have read this but none could offer a solution. I did some research myself and solved this by using the Vlookup function of excel. Thanks for reading my post anyway

Bye

Alphonse