Changes to one table being reflected in other sheets

[Meggo12]

Hello,

I apologize if this is too complicated. Basically I have a workbook that will track changes made to attributes. There are 21 dimensions, and 200 attributes (some repeating) distributed among those dimensions. I'm trying to build a tool that will show where all attributes are in the dimensions and track changes. The first sheet is a map of where each attribute is (I've already figured out the formula for that one). The second sheet is a list of the dimensions and what attributes are in each. After that, I would like to have a sheet for each dimension with a blank table, and the list of attributes in that dimension below. The table is where the edited/deleted/split attributes that are decided on will go. For example, if I want to split ATT-011 into 2, I would type into the table ATT-011A - description, and ATT-011B - description. I would do that for every attribute I want to keep, get rid of or change.

What I need is for that table to show in the second sheet, which feeds into the first.

If possible, it would also be best for each change to be reflected for that attribute everywhere. So if I split ATT-011 into two attributes (ATT-011A and ATT-011B) in the first dimension's sheet, then everywhere in the tool where ATT-011 is, it would split into the two.

I've attached a file that shows what I'm talking about.

Please let me know if you can help with any of these features!

[zbor]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-gene...er-sheets.html

Thread Closed.