Im at work and have to do a massive excel project with a single file that has 36 different sheets in it. A lot of the stuff is repititious, for example from sheet to sheet several will contain "6332 (Armstrong)", or "6355 (Shimshock)", or "6341 (Manriquez)". Is there a way to make ALL the cells in the ENTIRE file, every single sheet, contain a formula so that if i type in those first numbers of those sequences that it will automatically fill in the names after that when I press enter? Its bothersome to hold shift, type a parenthesis, type name one cap, let go of shift, type rest of name, hold shift and close parenthesis.

I know Excel auto does it for information in the same row or column if its in the same sheet, but when I start a new sheet (in this case each sheet is a different month for 3 years), it loses its repitition.

Copy and paste? Honestly I don't know.

Copy and paste works for one item...not 10-12 at one time.

You can't select a range/area of values?

Excell has an auto-correct option like Word so you can tell it when you type '6332' to always replace it with '6332 (Armstrong)', although you'll have to set all of the rules up manually.

Alternatively you could setup a single rules sheet (hide it later) with an index of all the entries in one column and their number codes in the column to the left, and then for each of the repetitive entries use an Offset(Index( kind of formula with a Match or two thrown in. It's a bit of work in the short-term but it might save you time in the long-term.

It could be done. Coding yourself a new function in the VBA editor is probably the best way to do it. It takes a while to learn how to use VBA though, perhaps if you looked around on the internet you could either find someone who already coding something like this, or someone who would be willing to do it for you.

If you made a list of people, you could use a combination of lookup functions and concatenate so that entering the number into one cell would create the full "(####) Name" in the next cell. Then, if the cell with the name in has to be text and not a function, just copy it and paste special back over it as values only and remove the original column used to enter the numbers.

EDIT: Meh, I was bored enough to make a quick example of what I was talking about.