I'm trying to figure out the right way of writing this idea, I need some help!
! Ok we start off in wrkbk A and start in cell A1(which is an invoice #) we
copy cell A1 and search for the contents of cell A1 in wrkbk B if found copy
cell + 9 cells to the left and past to cell M1 in wrkbk A. then Next line
repeat same process; if not found go back to wrkbk A and go to the next line
and repeat. Oh yeah when it's searching for content of cell A1 the invoice #
may be in wrkbk B,C or D... any ideas?

--
Message posted via http://www.officekb.com