Forwarding Entries to another Worksheet
Posted by Mark on August 03, 2001 2:18 PM
I want to enter multiple variable criteria (M3*, J9 etc.) into a cell which will cause information in the previous 3 cells to be forwarded automatically to another worksheet. Is there a formula for this? Example:
A1 = Doe, B1 = John, C1 = English, D1 = J9
I want cell range A1:D1 to be forwarded to another worksheet. J9 could appear numerous times as could other specified variables. Suggestions?