Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can anyone help with copy-finding macro?
I have a huge problem. I have a xls. file being created as an export from another program. It has a number of worksheets with text data in 4 columns. the task is to find copies of text in same columns of 2 sheets and do that for all pairs of sheets. the result i need is a new sheet with information what common objects in same columns does each pair of sheets have. for example : sheet1 and sheet2 have: text1, text5, text9 in column A anothertext1, anothertext4 in column B sheet1 and sheet3 have: no duplicates in column A no duplicates in column B sheet2 and sheet3 have: text1 in column A no duplicates in column B i'm not that so good in VBA, but i really need this to be done... i will really appreciate your help -- popovsky ------------------------------------------------------------------------ popovsky's Profile: http://www.excelforum.com/member.php...o&userid=25309 View this thread: http://www.excelforum.com/showthread...hreadid=388611 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Macro - Finding rows with data to copy | Excel Worksheet Functions | |||
Finding row, then copy paste (macro) | Excel Discussion (Misc queries) | |||
Finding Text To Copy To Another Worksheet | Excel Worksheet Functions | |||
Automate Finding Values/Copy to Different Sheet | Excel Programming | |||
Finding a Row and cut and copy | Excel Programming |