On Mon, 12 May 2008 14:38:00 -0700, KD wrote:

Actually only the values in the example are the same. My protection classes
go to 10 and because it started word wrapping into the other part of my table
in my example I only took the table over to 5. In the actual table there are
differences as you go across the columns. I also failed to add that I have
multiple tables. I have made sure that all the data ranges for each table are
in the same cells. I've created the worksheet/table name with a concatenate
formula and put that in a cell. So I should just be able to reference that
cell for the worksheet/table.

Then my first formula should work
--ron