PDA

View Full Version : Custom data transfer based on criteria



Richard Smit
08-26-2008, 02:45 AM
Hi All,
I have yet another tough situation on hand.. I have an excel workbook, with names on one work sheet. I have the same names or more on the next with additional information like age, class and so on. I'm in need to create a new workbook, such that if the name is present in the first sheet and the same is available in the second as well, then I will need the entire row copied and pasted in a new workbook. This will need to happen
for all the names in the first sheet. I have huge records to take care off. Currently I do this manually and its tiring. Please help guys.. Looking forward to your help and much appreciated. I've attached a sample workbook,that might be of help. If you can help me with a sample workbook with the solution it would be of great help and help me learn as well.

Thanks,
Richard Smith

Bob Phillips
08-26-2008, 02:49 AM
Examples?

Richard Smit
08-26-2008, 06:54 PM
My Apologies xld.. i forgot to attached the excel