Hello, I hope you can help.

I have a basic table with many rows but only four columns.
I have hidden this table from view and created a drop down
list so that column A is fixed based only on information
that is valid, because I put it there. What I want to
happen then is that columns B, C and D will update their
content directly based upon the data selected in column A.
Effectively the table will be duplicated but only for the
row of interest.

Thanks in advance,

Dan