Excel: find and replace

Microsoft Windows xp professional w/serv...
June 19, 2010 at 19:27:09
Specs: Windows XP
I have 2 sheets, sheet one has the folloing information in col A 'ref number' in col B 'issue number' e.g.
S254A A
S255A A
S256A A
S257A A
S258A A
sheet two has the folloing information in col A 'ref number' in col B 'issue number' but the col B information is different e.g.
S254A B
S255A B
S256A D
S257A C
S258A A
Now i need to create a function of marco to find the exact same ref number from col A sheet 2 to col A sheet 1, once it has found the same number I then need it to replace col Bs information in sheet 1 with the correct infomation from col b sheet 2.
Hopefully this make sense

See More: Excel: find and replace

Report •

#1
June 19, 2010 at 20:22:22
re: Now i need to create a function of marco...then need it to replace col Bs information

Is there some reason that you are telling us what you need?


Report •
Related Solutions


Ask Question