I need help to merge two files. Any help or macro will be highly
appreciated.
I have two files. file A and file B. Need to update FILE A from File
B.
Each file has hundred of rows and about 50 column.
If any word or phrase under column "Part" file A matches with any word
under column "Part" file b, then copy all the data of matching COLUMN
"PART" and corresponding column "NAME" from file B to matching COLUMN
"PART" AND corresponding column "NAME" FILE A.
See example
File A
NAME PART
1. power done 2, power done 3, hello,
mike, jeans, peter, walsh
2. I. Bergquist, T. Thomas, J. Mathers, C SMITH,
JOHNSON, WILLIAMS, JONES, BROWN,
3. Samnatha Place, For Ever, Since Mickeley,
Annie, Houser Gregory
4. power done 2, power done 12, hello,
mike, jeans, peter, walsh wili
File B
NAME PART
1. william shakespear, obama nathan calcultor,
diagos
2. power done, power done 2, power done 3, mike, jeans,
peter, walsh, hello, billo
3. Bergquist Titan, Thomas J SMITH,
BROWN1,
4. Samnatha, John, David, Bonnie Mickeley, Annie,
Houser Gregory
5. power done, power done 2, power done 2, hello, mike1,
jeans1, peter1, walsh wili1
If any word under colum Part from file A matches with any word in
column PART file B
Copy data from file b to file A in match Colum Part and corresponding
Column Name.
for example word hello matches from B1 OF FILE A with B2 AND B5 of
file B,
so copy whole B2 AND B5 from file B to B1 of File A
also copy whole A2 AND A5 from file B to A1 of File A
Example as follows.
There is possibility that matching word contain in more than one row
like this example ROW 2 AND ROW 5.
Each cell contains words or phrase separated by commas. There are
several phrases and words in each rows.
Final file
NAME PART
1. power done 2, power done 3, hello,
mike, jeans, peter, walsh
power done, power done 2, power done 3 mike, jeans,
peter, walsh, hello, billo
power done, power done 2, power done 2, hello1, mike1,
jeans1, peter1, walsh wili1
2. I. Bergquist, T. Thomas, J. Mathers, C SMITH,
JOHNSON, WILLIAMS, JONES, BROWN,
Bergquist Titan, Thomas J SMITH,
BROWN1,
3. Samnatha Place, For Ever, Since Mickeley,
Annie, Houser Gregory
Samnatha, John, David, Bonnie Mickeley,
Annie, Houser Gregory
4. power done 2, power done 12, hello,
mike, jeans, peter, walsh wili
power done, power done 2, power done 3, mike, jeans,
peter, walsh, hello, billo
power done, power done 2, power done 2, hello1, mike1,
jeans1, peter1, walsh wili1
Any help would be highly appreciated. Please reply asap.
Thanks in advance.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
