Hi everybody,
Apologies if this has been answered previously, as it strikes me as the kind of thing that lots of people ask questions about - just different variations of the same thing. I've been looking for weeks for a solution to this problem, and I can't for the life of me work it out.
I need a front summary page that provides an accurate reflection of the data within. In this instance (and as I've tried to reflect in my example sheet) I need to provide an efficient indication as to which positions (or in the example, numbers) are open without manually going through sheet by sheet and cutting and pasting those numbers/positions which are open.
So for example; I have the following data
Example 1 - On Sheet Two
1 Open
2 Open
3 Closed
4 Open
5 Closed
6 Closed
Example 2 - On Sheet Three
7 Closed
8 Open
9 Closed
10 Closed
11 Closed
12 Open
So on Sheet One I want to automatically display all the rows within the other two sheets that are 'Open' as indicated via column B.
Is this more complicated than I think it is? Because I can't work it out.
Thanks so much for your help.
Yours,
SIL
Bookmarks