Hi it's me again!!
I had a quick question does anybody have any suggestions on how to run a
macro that does the following: I need it to search for 123 (which is in
wrkbk 1) but when it searches for it it needs to add a AB123 in front and
there are about 47000 numbers to reasearch. Any Ideas?
ex.

Wrkbk1 Wrkbk2 wrkbk3 wrkbk4 wrkbk5
wrkbk6 wrkbk 7
123 - - -
- AB123 -

so take it found the match take coulmn a - o and place in wrkbk 1 in column o

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1