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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cheese_whiz - 26 Nov 2007 19:58 GMT

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

Reply to this Message

Bernard Liengme - 26 Nov 2007 21:53 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Hi all,
>
[quoted text clipped - 10 lines]
> Thanks,
> CW

Reply to this Message

Cheese_whiz - 27 Nov 2007 18:17 GMT

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

> Something like =Sheet!A1 should work
> Best way is: type =, open the other sheet and click the cell; press Enter
[quoted text clipped - 14 lines]
> > Thanks,
> > CW

Reply to this Message

Gord Dibben - 26 Nov 2007 22:11 GMT

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

>Hi all,
>
[quoted text clipped - 8 lines]
>Thanks,
>CW

Reply to this Message

Cheese_whiz - 27 Nov 2007 18:17 GMT

Thanks for the reply.

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

> See help on VLOOKUP formulas to be entered on your "form" sheet.
>
[quoted text clipped - 16 lines]
> >Thanks,
> >CW

Reply to this Message

Rate this thread: