I'm trying to figure out how I can automatically have data inserted into one
worksheet copied to another based on an identifier. For example...In my
first worksheet (i'll call it "all data") I want to use the first column to
give each line item an identity (in this case either the letter "a" or the
letter "b"). Once I've input all of my line items I want to have a formula
that will automatically copy all the line item data for those lines
identified with an "a" to a separate worksheet (I'll call it "A"). I want to
be able to do the same for by "b" line items. In the end I should have three
worksheets. the first contains all by "a" and "b" items in aggregate. The
second is only the "a" items (as extracted by the formula using the "a"
identified) and the third worksheet is the "b" items (as extracted by the
formula using the "b" identifier). Can this been done? Could I reverse it
and somehow input the data into the "a" and "b" worksheets and then use a
command to aggregate them into the "all data" worksheet?