On May 22, 12:25 pm, Tom Ogilvy
wrote:
Code may be a possibility, but
It sounds like data validation under the data menu using the list option.
the remainder of the changes could be done with formulas.

If you don't see the formulas, then perhaps those cells are locked and the
formulas hidden.

--
Regards,
Tom Ogilvy



"davegb" wrote:
Everytime I think I'm getting pretty smart about XL, I see something
new I've never seen before. I'm working on a spreadsheet that was
given to us by a consultant. It has a neat feature I haven't seen
before that I'll try to describe.

There is a column header with text in it in Column E. If another cell
is selected, it looks like a normal column header. But if I select
that cell, a tiny control button with a down arrow in it appears to
the lower right of the cell, actually in the lower left corner of the
cell to the right of the header cell I selected. If I click on the
little arrow, a tiny menu appears, with 2 options. One is the column
header I've been seeing, the other is a different column header which
I can select. That changes the original column header to the new one.
But it also changes the 2 columns to the right of the original column,
columns F & G. Until I select the alternate column header in E, F is
blank, and G has a "normal" column header and numbers down the column.
But when I select the alternate column header in E, column G goes
blank, and F appears with a header and numbers. Of course, other cells
in the spreadsheet are dependents on these columns, based on IF
statements testing the text in the original column header. Pretty
slick! I'm sure some of you here know how to do this. Can someone
explain it to me? Not looking for step-by-step yet, just a general
idea of how it's done.

As always, thanks!- Hide quoted text -

- Show quoted text -

Thanks for the replies. I should have mentioned in my first post, that
there is no code anywhere I know to look for it. No modules, and no
code behind any of the sheets. I thought at first it was probably an
event driven macro.

It's data validation, which I've heard of but never seen used. Thanks
for letting me know. Now I guess, when I have some time, I've got to
go look that up and see how it works!