danlu
03-09-2008, 10:18 AM
Hi,
I have a large amount of data which is ordered by the values in the A column, that is, first is all data which has the word alpha listed, then comes all data with value beta and so on. For ex column A,B and C could look like this:
alpha 10 20
alpha 10 20
beta 15 cat
beta dog 12
so I want to copy all data (from column A,B and C) with value alpha in column A on Sheet1 to Sheet3, all data with value beta in column A on sheet1 to Sheet4 and so on.
Which would give the following look at Sheet3 (in column A,B and C):
alpha 10 20
alpha 10 20
and sheet4 would look like:
beta 15 cat
beta dog 12
and go on like this on every unique Sheet for as many sheets as there are unique values(categories) in column A on Sheet1.
If possible it would be good if each tab could be named the same thing as the name of the value (category) that ends up on that specific sheet. For ex the sheet (in this ex sheet3) which ends up with data belonging to value alpha in column A should be named Alpha.
To have data belonging to a value in column A in only two columns was only an example. Generally there are data in more columns and of course all attached data (not only data in column B,C) should be copied to the unique sheet dedicated for a unique value (category) in column A from sheet1.
I have a large amount of data which is ordered by the values in the A column, that is, first is all data which has the word alpha listed, then comes all data with value beta and so on. For ex column A,B and C could look like this:
alpha 10 20
alpha 10 20
beta 15 cat
beta dog 12
so I want to copy all data (from column A,B and C) with value alpha in column A on Sheet1 to Sheet3, all data with value beta in column A on sheet1 to Sheet4 and so on.
Which would give the following look at Sheet3 (in column A,B and C):
alpha 10 20
alpha 10 20
and sheet4 would look like:
beta 15 cat
beta dog 12
and go on like this on every unique Sheet for as many sheets as there are unique values(categories) in column A on Sheet1.
If possible it would be good if each tab could be named the same thing as the name of the value (category) that ends up on that specific sheet. For ex the sheet (in this ex sheet3) which ends up with data belonging to value alpha in column A should be named Alpha.
To have data belonging to a value in column A in only two columns was only an example. Generally there are data in more columns and of course all attached data (not only data in column B,C) should be copied to the unique sheet dedicated for a unique value (category) in column A from sheet1.