Insert column entries from a master list
 

I have a series of wooksheets, each with an identical list of alphabetical
names, which are imported from a master list located on the last worksheet of
the workbook. (Master!A1...Master!A2...etc.) Naturally each of the names has
additional columns of entries & formulas associated with them. I need to be
able to insert new names anywhere in the master list, which will
automatically be transferred to each of the preceeding worksheets in the
proper location. In other words, adding a name to the master list must insert
a new row with that name in the corresponding place in each preceeding
worksheet, and shift all existing names down one row. Any help is greatly
appreciated. If you respond please try not to be too technical. :-)
(Excel 2000, Windows 98se)

Good evening,
If your purpose is to keep the alphabetical order by inserting rows in the
master list, this is not the best way to do it. Type the new names at the
end of the list and then sort the column. This will update also the
preceding sheets.
I hope I was helpful.

"RichLorn" wrote:
I have a series of wooksheets, each with an identical list of alphabetical
names, which are imported from a master list located on the last worksheet
of
the workbook. (Master!A1...Master!A2...etc.) Naturally each of the names
has
additional columns of entries & formulas associated with them. I need to
be
able to insert new names anywhere in the master list, which will
automatically be transferred to each of the preceeding worksheets in the
proper location. In other words, adding a name to the master list must
insert
a new row with that name in the corresponding place in each preceeding
worksheet, and shift all existing names down one row. Any help is greatly
appreciated. If you respond please try not to be too technical. :-)
(Excel 2000, Windows 98se)