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

  • Thread starter Thread starter Cheese_whiz
  • Start date Start date
C

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
 
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
 
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
 
Back
Top