View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Cheese_whiz Cheese_whiz is offline
external usenet poster
 
Posts: 25
Default Auto input data on one sheet based on row selected in another shee

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