Moving Row data to sheet

T

tomc112

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

Let me explain. I will have 2 worksheets Lets say A and B. In Workshee
A I have rows and rows of data. In worksheet B I want to create a for
(not excels form one written in the spreadsheet itself no VB) that wil
contain info from each row singly only. 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 i
sheet B. I know this is done in Access very easily with a table and
form but can it be done in exce
 
O

Otto Moehrbach

Do you mean that when a row in Sheet A is clicked in (anywhere in the row?),
you want certain data from that row to copy to Sheet B?. This would require
VBA with an event macro. Is this what you had in mind? HTH Otto
 
Top