Enter the identifying information (assume name) and then populate other
cells with formulas using Vlookup.

See help on Vlooup for details

Assume the name entered in B3 of Sheet2

=if(b2="","",Vlookup(b2,Sheet1!A:F,3,False))

this would return "Nights Staying" or column C from sheet1 for the matching
name.

You can put in a dropdown in B2 which has all the name from which to choose
by using data = Validation.

See Debra Dalgleish's site for information on using Data =Validation.

Debra Dalgleish
http://www.contextures.com/tiptech.html

Datavalidation - top
http://www.contextures.com/xlDataVal01.html

Dependent lists - data validation
http://www.contextures.com/xlDataVal02.html

--
Regards,
Tom Ogilvy


"Capt. Attitude" <Capt. wrote in message
...
Hi all,

I know this should be obvious and easy but I can't find the answer
anywhere,
probably because I don't the terminology.

Anyway, my wife has an Excel worksheet with rental data for her business,
things like name, address, nights staying, etc. (Sheet 1) and so I made
another sheet in her workbook as an invoice (Sheet 2) and embedded the
data
from Sheet 1 and now don't laugh but I can't figure out how to get the
invoice to "move" through the rows of Sheet 1 (i.e. have a drop-down or
something to change the invoice data (Sheet 2) from Mr. Jones' info on row
3
of Sheet 1 to Mr. Smith's info on row 7 of Sheet 1).

Sad to say, the only way I've figured out how to do it is to do a Find and
Replace of $3 to $7 on my invoice sheet to accomplish this...not very
effecient.

I know this has to be an obvious feature...feeling pretty stupid...please
help...