sharing rows of data across multiple worksheets within a workbook
 

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?

deedle-dee-dee,
drill back ten posts before yours, where Gene Simmons' similar query is
answered
by Harlan Grove. It may work for you.
bushp04

"deedle93" wrote:

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?

Thanks - I saw that post but wasn't sure it would work as I'm trying to copy
over an entire row of data vs a single cell. I'm also trying to copy over
all rows that have the same identifier in the first column of each row.

Many thanx for your reply.

"bushp04" wrote:

deedle-dee-dee,
drill back ten posts before yours, where Gene Simmons' similar query is
answered
by Harlan Grove. It may work for you.
bushp04

"deedle93" wrote:

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?