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

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Cheese_whiz" wrote in message
...
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

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

On Mon, 26 Nov 2007 11:58:00 -0800, Cheese_whiz
wrote:

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

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

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Cheese_whiz" wrote in message
...
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

Thanks for the reply.

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

"Gord Dibben" wrote:

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

On Mon, 26 Nov 2007 11:58:00 -0800, Cheese_whiz
wrote:

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