Ann_BBO
10-21-2009, 05:15 AM
Hi All,
I have the 2 files. One is A file and one is B file.
A file contains a many “Blocks”. Each Block has a corresponding mapping table and Offsets. Address = “Block + Offset”.
Example in A file:
http://img197.imageshack.us/img197/5946/screenhunter01oct212007.gif
B file has the “Address” and “Changed Value” that I would like to update to A file.
Example in B file:
http://img197.imageshack.us/img197/4417/screenhunter02oct212007.gif
The comparison method is : Checking the “Address” and “Name”. Note that “Name” in B file format has the comma and space between each sentences. If both are identical to address and Name in A file, then update the “Changed value” into A file and cell shading with yellow color on corresponding cell in A file.
Expect Result:
http://img62.imageshack.us/img62/2341/screenhunter03oct212008.gif
Difficulties to me :
In A file, how to combine the address from block and offset so that it can do a comparison. Since Block and table haven’t a constant space or it may have a word between them. My idea is find the “Block” word with Bold features. Then, move download (offset) to the row until we meet the green color cell shading.I hope that someone can give me idea to me. Thanks
p.s. Since the max attached file is one. Therefore, i combine 3 excel files to one.
Thanks®ards,
Ann
I have the 2 files. One is A file and one is B file.
A file contains a many “Blocks”. Each Block has a corresponding mapping table and Offsets. Address = “Block + Offset”.
Example in A file:
http://img197.imageshack.us/img197/5946/screenhunter01oct212007.gif
B file has the “Address” and “Changed Value” that I would like to update to A file.
Example in B file:
http://img197.imageshack.us/img197/4417/screenhunter02oct212007.gif
The comparison method is : Checking the “Address” and “Name”. Note that “Name” in B file format has the comma and space between each sentences. If both are identical to address and Name in A file, then update the “Changed value” into A file and cell shading with yellow color on corresponding cell in A file.
Expect Result:
http://img62.imageshack.us/img62/2341/screenhunter03oct212008.gif
Difficulties to me :
In A file, how to combine the address from block and offset so that it can do a comparison. Since Block and table haven’t a constant space or it may have a word between them. My idea is find the “Block” word with Bold features. Then, move download (offset) to the row until we meet the green color cell shading.I hope that someone can give me idea to me. Thanks
p.s. Since the max attached file is one. Therefore, i combine 3 excel files to one.
Thanks®ards,
Ann