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.
…