Your project would be way much easier to manage and work with if you
get into the habit of using local scope defined names for ranges. You
already have done the ground work for setting this up to use the
numeric value above the data. The numbering coincides with the table at
the top of the sheet. Using defined names will allow you to enter the
same formula for all numbered columns, but it will auto-adjust to ref
the appropriate value in your table. This approach would use the
numbers as an "index" to which column of the table to pull values from.

If something of this nature is beyond your level of skill then attach
your file so someone can perhaps do this for you. If your reader won't
allow attachments then upload the file to a webshare and post a link.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion