I have an Excel problem and I was wandering if anyone could give me
their 2 Cents worth.

Let me explain. I will have 2 worksheets Lets say A and B. In
Worksheet A I have rows and rows of data. In worksheet B I want to
create a form (not excels form one written in the spreadsheet itself no
VB) that will contain some of the info from each row. Like for
example....


Sheet A : Row 1 Name, Phone, Address
Row 2 Name, Phone, Address

Sheet B: From highlighted row 1 Name Address


What I would like is each time you click a row the info changes
in sheet B. I know this is done in Access very easily with a table and
a form but can it be done in excel


--
tomc112
------------------------------------------------------------------------
tomc112's Profile: http://www.excelforum.com/member.php...o&userid=16816
View this thread: http://www.excelforum.com/showthread...hreadid=320131