Thanks for all your help, i appreciate it.

The search will not be case sensitive and there should only be one hi
in the column. If there is more than one hit I would like there to b
an error message, but that may be beyond my immediate concerns for now


The larger idea behind the question is a search and update between tw
spreadsheets. I am hoping to write a macro that will select the firs
alpha-numeric name from spreadsheetB in column G. The macro will the
search spreadsheetA, column J for the alpha-numeric name. Once it ha
been located, values from their respective rows will b
summed/differenced. For example, AAAA#### from G3 (spreadsheetB) is th
first item. The macro would then search column J for AAAA####. Onc
found (for example in J50), the value located in F3 (spreadsheetB) wil
be added/subtracted from F50 (spreadsheetA).

The process would begin again at G4 and continue till spreadsheetB wa
complete.

I hope that helps

--
merritt
-----------------------------------------------------------------------
merritts's Profile: http://www.excelforum.com/member.php...fo&userid=3580
View this thread: http://www.excelforum.com/showthread.php?threadid=55859