Open select Cells by clicking a particular cell

[gjmac2]

I have a general question. Is it possible to create a table in Excel with column headers that, when clicked, will allow allow data entry to specific assigned cells?

For example, say that every time I clicked the Name in column B Row 1, that Cells B4 through B8 would open for data entry. Is this possible?

Thanks in advance.

 

[kjv1611]

I believe that what you'd have to do for something like that is use some custom VBA programming. And if that's all you need it to do, it wouldn't be difficult. If that's the route you want to take, try asking for help in the following forum, assuming you'd need help getting it going:

forum707

--

"If to err is human, then I must be some kind of human!" -Me

 

[gjmac2]

Thank you very much. I will post this question there.