Auto input data on one sheet based on row selected in another shee

[Cheese_whiz]

Hi all,

I have a worksheet that contains rows of data. I also have setup a 'form'
(in the general sense of the word) on another worksheet. What I want to do
is take data from the selected row on the first worksheet and automatically
fill cells on that second worksheet (the 'form') with it.

Is that possible? If so, can someone give me an example of a formula that
would do it?

Thanks,
CW

 

[Bernard Liengme]

Something like =Sheet!A1 should work
Best way is: type =, open the other sheet and click the cell; press Enter
Key or click green check mark on Formula bar
best wishes

 

[Gord Dibben]

See help on VLOOKUP formulas to be entered on your "form" sheet.

Or go to Debra Dalgleish's site for more on VLOOKUP and a sample workbook..

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

 

[Cheese_whiz]

Thanks for the reply.

The problem I'm having is that the formula isn't based on a particular cell,
but based on the value of the intersection of a column and row where the row
is always changing.

That's why I was trying to find out whether or not a 'selected' row (read:
a row that has been selected by clicking it's row number) could somehow be
referenced in either a formula or possibly in vba.

What I wanted to do was get the value from 'the A column of the selected row
on sheet 1'. I know it's a stretch, but in access vba you can identify
controls as being selected or not...

Thanks again,
CW

 

[Cheese_whiz]

Thanks for the reply.

I'll take a look at it. Thanks for the link.
CW