formula/method help

%3CLINGO-SUB%20id%3D%22lingo-sub-3177049%22%20slang%3D%22en-US%22%3Eformula%2Fmethod%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3177049%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22main.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348956i4236E48CC1AEE632%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22main.jpg%22%20alt%3D%22main.jpg%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22work1.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348957iA45E81EC7357BE99%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22work1.jpg%22%20alt%3D%22work1.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ehi%20everyone%3C%2FP%3E%3CP%3Enew%20member%20here%20and%20even%20a%20beginner%20user%20to%20excel%3C%2FP%3E%3CP%3Ei%20have%20excel%20sheets%20with%2060%2C000%20entries(image%201)%20and%20i%20need%20to%20categorize%20them%20into%20another%20sheet(image%202)%20with%20the%20same%20format.%20my%20question%20is%2C%20since%20what%20i'm%20doing%20now%20is%20copy%20paste%20but%20that%20takes%20a%20lot%20of%20time%20with%2060%2C000%20entries%20and%20that's%20just%20one%20sheet.%20if%20you%20look%20at%20column%20A%2C%20numbers%2017%2C%2018%2C%2019%20and%20until%20the%20end%20with%20number%201349(not%20included%20in%20screenshot)%20what%20method%2Fformula%20i%20can%20use%20to%20copy%20all%20data%20between%20each%20two%20numbers%20(17%20%26amp%3B%2018%2C%20then%2018%20%26amp%3B%2019%2Cetc)%20into%20the%20other%20sheet%20without%20having%20to%20manually%20copy%20paste%20each%3F%3C%2FP%3E%3CP%3Ethanks%20a%20lot%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3177049%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

main.jpgwork1.jpg

hi everyone

new member here and even a beginner user to excel

i have excel sheets with 60,000 entries(image 1) and i need to categorize them into another sheet(image 2) with the same format. my question is, since what i'm doing now is copy paste but that takes a lot of time with 60,000 entries and that's just one sheet. if you look at column A, numbers 17, 18, 19 and until the end with number 1349(not included in screenshot) what method/formula i can use to copy all data between each two numbers (17 & 18, then 18 & 19,etc) into the other sheet without having to manually copy paste each?

thanks a lot in advance

0 Replies