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)