Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping Large List
All,
I need you to please help me in the below issue: I have a 25000-line list of items numbered. But inorder to perform an operation in the softare I use to pull data I need to feed only 1000 numbers at a time. How do I group the list the way each group will have 1000 lines? What I am doing right now is that I select the firist cell, shift+drag down to reach 1000 and name the group with for instance, "A", then go to the next cell repeat the drill ..."B", and so on so forth. What is the easyest way to do that? Any Excel functions that you would prompt me with. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping Large List
I think I would ask if you can increase the number of lines to be uploaded?
If not, then are you expecting 25 sheets with 1000 each to upload one at a time? This can be done with a macro on the data sheet with 25k lines and having 25 sheets. You can record one and it should be easy to follow. example: Rows("1:999").Select Selection.Copy Sheets("1").Select Rows("1:999").Select ActiveSheet.Paste Sheets("data").Select Rows("1000:1999").Select Selection.Copy Sheets("2").Select Rows("1000:1999").Select ActiveSheet.Paste Sheets("data").Select "alish" wrote: All, I need you to please help me in the below issue: I have a 25000-line list of items numbered. But inorder to perform an operation in the softare I use to pull data I need to feed only 1000 numbers at a time. How do I group the list the way each group will have 1000 lines? What I am doing right now is that I select the firist cell, shift+drag down to reach 1000 and name the group with for instance, "A", then go to the next cell repeat the drill ..."B", and so on so forth. What is the easyest way to do that? Any Excel functions that you would prompt me with. Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping Large List
Don,
Thanks for the quick reponse, but how do i perform that in the same sheet? "Don" wrote: I think I would ask if you can increase the number of lines to be uploaded? If not, then are you expecting 25 sheets with 1000 each to upload one at a time? This can be done with a macro on the data sheet with 25k lines and having 25 sheets. You can record one and it should be easy to follow. example: Rows("1:999").Select Selection.Copy Sheets("1").Select Rows("1:999").Select ActiveSheet.Paste Sheets("data").Select Rows("1000:1999").Select Selection.Copy Sheets("2").Select Rows("1000:1999").Select ActiveSheet.Paste Sheets("data").Select "alish" wrote: All, I need you to please help me in the below issue: I have a 25000-line list of items numbered. But inorder to perform an operation in the softare I use to pull data I need to feed only 1000 numbers at a time. How do I group the list the way each group will have 1000 lines? What I am doing right now is that I select the firist cell, shift+drag down to reach 1000 and name the group with for instance, "A", then go to the next cell repeat the drill ..."B", and so on so forth. What is the easyest way to do that? Any Excel functions that you would prompt me with. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List top five results based on age grouping | Excel Worksheet Functions | |||
Grouping large amount of data by day-of-week | Excel Discussion (Misc queries) | |||
Producing an automated list from a large list | Excel Worksheet Functions | |||
Random Grouping/Fixture List?? | Excel Worksheet Functions | |||
remove small list from large list | Excel Discussion (Misc queries) |