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