entering 1 cell fills the worksheet

[CaitlinC Pro Honda]

I am trying to create an fool proof seris of worksheets where if you enter
the name of the dealership only the rest of the information will appear. I
have seen it doen once before. we have 7 dealerships. Can anyone help me

 

[Max]

One way ..

Try this working sample file from my archives which illustrates:
http://www.savefile.com/files/387065
Display specified name range.xls

Selecting from the DV droplist in B2 will fill the range in B4:F9