Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
seggregation of rows based on values in column
hi .
i need an idea to go about with this kind of a requirement: i have to create a macro whereby my input file has a sheet "X", which has a column customer_info. this sheet has around 20000 lines. I have divide this sheet into 5 other sheets based on the value in the column 'customer_info'. Now the column has around 20 differnet values in the 20000 rows. I have to segrigate sheets based on values like: A0DAUA (all rows with this values say 5000 rows will be copied and pasted in sheet "A") GGG0DAUA (all rows with this values say 5000 rows will be copied and pasted in sheet "B") XXXD098 (all rows with this values say 5000 rows will be copied and pasted in sheet "C") DGHJSLK (all rows with this values say 1000 rows will be copied and pasted in sheet "D") and all the remaining values (4000 rows) in one sheet "E" What should the approach I should follow...how can i trap all those with value A0DAUA or GGG0DAUA or XXXD098 .... and seggregate them... i hope i am clear... pls suggest. thanks in advance... monica |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
seggregation of rows based on values in column
check out data, auto-filter;
"monica" wrote in message ... hi . i need an idea to go about with this kind of a requirement: i have to create a macro whereby my input file has a sheet "X", which has a column customer_info. this sheet has around 20000 lines. I have divide this sheet into 5 other sheets based on the value in the column 'customer_info'. Now the column has around 20 differnet values in the 20000 rows. I have to segrigate sheets based on values like: A0DAUA (all rows with this values say 5000 rows will be copied and pasted in sheet "A") GGG0DAUA (all rows with this values say 5000 rows will be copied and pasted in sheet "B") XXXD098 (all rows with this values say 5000 rows will be copied and pasted in sheet "C") DGHJSLK (all rows with this values say 1000 rows will be copied and pasted in sheet "D") and all the remaining values (4000 rows) in one sheet "E" What should the approach I should follow...how can i trap all those with value A0DAUA or GGG0DAUA or XXXD098 .... and seggregate them... i hope i am clear... pls suggest. thanks in advance... monica |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I number rows based on unique values in another column? | Excel Worksheet Functions | |||
Deleting rows based on column values | New Users to Excel | |||
Summing rows based on other column values | Excel Worksheet Functions | |||
Column seggregation | Excel Discussion (Misc queries) | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions |