Hello,

I'm kind of an Excel moron... so I need some help please.

OK, we have a spreadsheet with 4worksheets within it where the "master
worksheet" an inventory of all of our businesses' offices, number of
employees, and other information... then the other three worksheets are for
each of our companies' three regions.

So, what I want to try to accomplish is when we add data to any of the three
regional worksheets, it will auto update the master worksheet based on
keyword matches from column B.

Let me explain that a little better:

So, in the master worksheet... column B might look like this (and on down
through about 70 values):

Akron, OH
Albany, NY
Allentown, PA
Atlanta, GA
Augusta, GA



Now in the regional worksheets, Column B will also have the same values, but
maybe column C has numerical values (like # of employees)... so in this
regional worksheet, I need to have a formula whereby if I add or change a
number, it will update the correlating value in row C in the master.
However, I don't wnat to lock this down to columns or rows, but rather do
the match when the office name value (Cited above) is a match.. because the
rows and columns will always be subject to change as we add and subtract
offices over time.

Gee, I hope that makes sense, it's a little tricky to explain in text.

Thanks,
Craig