I am using Excel to keep inventory. Let's assume the following situation: tracking newspaper articles by dates that I cut out. So, in Columns B to F and Row 1 for all of them, they each have dates. In Column A, Rows 2 to 10, are the newspaper articles' titles. Some of these articles are directly behind another article I am interested in. In other words, if I cut out an article about apples, on the back of it was an article about shoes, but the lengths were different, with the shoes article being longer, and so the article on shoes is no good / incomplete.
So, let's take Column B, Row 2 for example. If I put an X there or do something to that cell, I would like an X to automatically appear in Row 3 and Row 7 (so, in this case, cutting the article out listed in Row 2, resulted in two articles on the back being cut out completely or partially for one or both). With this same example, if I put an X in Row 3, I would like an X to automatically go in Rows 2 and 7. If I put an X in Row 7, I would like one to automatically appear in Rows 2 and 3.
To summarize:
X in B2, X to appear automatically in B3 and B7
X in B3, X to appear automatically in B2 and B7
X in B7, X to appear automatically in B2 and B3
Can this be done in Excel? If not, do you have any idea of what program I can use to keep track of something in this manner?
UPDATE: I have attached a file to show what I mean. The concept is the same, but different cells than those specified above are demonstrated. For each column, the cell with a yellow background was marked / had an X manually placed, and those in red, for the same column, are supposed to have the X added automatically. As you can see, for each column, the red cells corresponding to the yellow cells can be any set of cells. I would like a way to specify and link a set of cells per column, so that when any one cell of the linked set of cells have an X placed, the rest of the linked / grouped cells are updated / have an X placed in them. Note: I am saying to place an X to make things simple, but colored backgrounds without an X as I have in the attached file is also acceptable.
UPDATE 2: I have updated the file, making changes in Column B, tho show that I would be interested in more than one linked set of cells per column. So, for Column B, for the cell with the green background, the X was entered manually, and for the cells with the blue background, the Xs are supposed to appear there manually. As you can also see, in such a case, the Xs are not really needed / not enough to distinguish one set of linked cells from another. Colored backgrounds seems to be the best way to do this, unless there is some other way that I am not thinking of--some other way to structure / organize the data and achieve the same set of results.
So, again: Can this be done in Excel? If not, do you have any idea of what program I can use to keep track of something in this manner?
Bookmarks