Hi
use VLOOKUP for this (if column A contains unique values.). e.g. in B1
on your second sheet enter
=IF(A1<"",VLOOKUP(A1,'hidden_sheet'!$A$1:$D$100,2 ,0),"")

--
Regards
Frank Kabel
Frankfurt, Germany


Dan Eames wrote:
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