Display data FROM Sheet1 on Sheet2 based on conditional value
- by Shawn
Imagine a worksheet with 30 pieces of information, such as:
A1= Start Date
A2 = End Date
A3 = Resource Name
A4 = Cost
....
A30 = Whatever
B1 = 1/1/2010
B2 = 2/15/2010
B3 = Joe Smith
B4 = $10,000.00
...
B30 = Blah Blah
Now imagine a third column, C. The purpose of the third column is to determine WHICH report that row of data needs to appear in.
C1 = Report 1
C2 = Report 1 and Report 2
C3 = Report 4 and Report 7
C4 = Report 1 and Report 5
...
C30 = Report 2
Each report is on Sheets 2, 3, 4, 5 and so on (depending on how many I decide to create). As you can see form my example above, some data may need to appear in multiple reports. For example, the data in Row 3 (Resource Name: Joe Smith) needs to appear in Report 4 and Report 7. That is to say, it needs to DYNAMICALLY appear on two additional worksheets.
If I change the values in column C, then the reports need to update automatically.
How can I create the worksheets which will serve as the reports such that they only diaplay the rows which have been "flagged" to be displayed in that report?
Thanks!
