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!