I think you are making things hard for yourself.

It sounds as if your data is in a simple table with headings in row
and data underneath - which is a good start because you can use th
more powerful Excel features such as pivot tables and data filter t
summarise your data. You can then refer to the pivot table with
simple =VLOOKUP() formula. A lot can be achieved by adding columns t
the raw data table for lookup or calculation.

This means that any new data can be added to the bottom of the table

--
Message posted from http://www.ExcelForum.com