Hi

Would still love help on previous regarding 20 tables but in a panic. :(

I have now ref all tables to 1 long list so as a quick fix:

the col headings of the list are PC | Name | Rate | B | S |X | L1

In the report sheet I have a drop down list of the PC col.

I would like to be able to select the PC and the report be filled with the
following data only:

| Name | Rate | B | S |X | L1

I have used vlookup and tried to hack an old code that can be copied down
but it will only ever show the first record :(:(

Sorry for being thick..

Cheers
for all help and I am learning :)

UKMAN