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?
Posted by Cory on August 03, 2001 2:28 PM
I think it can be done, but can you be more specific? The "(M3*, J9 etc.)" is throwing me off. And where are you entering this multiple criteria?
Cory
Posted by Mark on August 03, 2001 3:45 PM
Cory, Thanks for your response. If the "(M3* or J9)" is entered in D1, I want that to be cause to forward A1:D1 to a new location on another worksheet. A list would compile from there of all M3*s and J9s. I hope my terminology and intent is comprehensive.
Posted by Cory on August 06, 2001 7:47 PM
One more thing and I think I can help you:
Are M3* and J9 cell references or are they just identifying text (Id #s or part numbers, say)
I'm thinking you can autofiler them by type and copy/paste them to the other sheet, but I'm not sure if that's right...
Cory
Posted by Mark on August 07, 2001 5:39 PM
Posted by Mark on August 07, 2001 5:43 PM
They are identifying text, not cell references. They are codes actually. I appreciate your assistance.....Mark
