You might try looking at VLookup to get you started, if you are trying to
find a value in various worksheets.
--
David


"Craig Harrison" wrote:

I get an Excel spreadsheet report that I need to bring over the store number
to and existing report. The common field for both is the client number. I get
this report every week and would like to automate the process. Right now I
have to go line by line through hundreds of stores. Is there a way I can set
this to automatically do what I am asking? Thank you for your help.