yes, it's possible to automate such report management in excel. best way is
to use macros or, even better, VBA. But, for start, vlookup will make
finding information easier...
"Craig Harrison" <Craig wrote in message
...
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.