OK, here is the file.

The first tab - Xander - is the basic data. The last tab - Reference - is the list of categories for each test.

The second tab is what I'd like Excel to automatically do though VBA. I'd want to be able for it to have unlimited test results with out having to copy the formatting or code. I'd assume I'd have code for "Glucose" for example, apply to row 11, regardless of the column designation.

Am I wanting something impossible?

Again, I'm pretty good with Access VBA, but have never worked with Excel VBA (other than having Access manipulate Excel files).

Thanks!

Susie
Kansas

Attached Files

Cat results.xlsx (27.7 KB, 9 views)