Frequently used data

[Chris White]

I have a client that uses Excel, and she has data that she
has to type in repeatedly. I have shown her how to define
an Insert Name, and that seems to work, but it only works
in the worksheet that she's working in. If she starts a
new worksheet, she has to create a new definition. Is
there a way to create a data base of some kind that can be
used in multiple worksheets, without having to create the
Insert Name definitions for each worksheet?

Example: If she enters "sch40" she wants the cell to fill
in "Schedule 40 Carbon steel pipe is 10 feet long, and has
a wall thickness of 3/4 inch..."

 

[Harlan Grove]

I have a client that uses Excel, and she has data that she
has to type in repeatedly. I have shown her how to define
an Insert Name, and that seems to work, but it only works
in the worksheet that she's working in. If she starts a
new worksheet, she has to create a new definition. Is
there a way to create a data base of some kind that can be
used in multiple worksheets, without having to create the
Insert Name definitions for each worksheet?

...

Create a workbook template containing the desired default defiend names.

 

[Chris White]

Thanks. That's the only solution I could come up with,
but I thought there might be another way. Thanks for your
input.

 

[Harlan Grove]

Thanks. That's the only solution I could come up with,
but I thought there might be another way. Thanks for your
input.

...

There is - Autocorrect - but the unintended consequences may be too horrible to
contemplate, or not. The benefit of a template is that you could build it for
your client. With Autocorrect, your client would need to make the entries or
you'd need to do so on your client's machine. Autocorrect also isn't portable,
so you or your client would need to do this on every machine on which your
client would want to do this.