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) |
All times are GMT +1. The time now is 11:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com