Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
RichLorn
 
Posts: n/a
Default 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)

  #2   Report Post  
AndreasN
 
Posts: n/a
Default

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)



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i see if entries in one column are in another column? mpt1 New Users to Excel 1 January 24th 05 09:35 PM
How do I arrange entries in a column alphabetically ferrymaster77 Excel Discussion (Misc queries) 1 January 21st 05 12:58 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 07:57 PM
Insert column entries from a master list RichLorn Excel Worksheet Functions 0 October 28th 04 08:59 PM
Insert column entries from a master list RichLorn Excel Worksheet Functions 0 October 28th 04 08:57 PM


All times are GMT +1. The time now is 12:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"