entering 1 cell fills the worksheet
 

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

entering 1 cell fills the worksheet
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CaitlinC Pro Honda" wrote:
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 done once before. we have 7 dealerships. Can anyone help me