group part numbers, blank line btwn unlike

[nkhasu]

i have a spreadsheet with 21,000 part numbers. I am trying to group the like part numbers, then leave a space between the unlike part numbers. right now my spreadsheet has a space between each part number and i want to eliminate that. but also keeping the part's qty, date, etc. with it.

any tips? ( i hope i posted in teh correct place)

[rwgrietveld]

To be able to help you we need to see the actual data. What are the differentiators between the parts?

[nkhasu]

it's all different part codes...for example i have 5 columns: date, quantity,description,part number, location. the part codes need to be grouped.

i need all the 4200562 (along with their date, descrip, etc) to be grouped without a blank row in between them. then i need to maintain the other part numbers that are only single (one of a kind) with a row between each.

right now on my spreadsheet i have a row between each part number. i just want to sort and get the same part numbers in a group, skip a line and then each other part number if they aren't in a group have a line between.

i'm sorry if i don't make sense...i'm trying my best! thanks for your help!

[rwgrietveld]

I understand, but please upload part of the WB and we can supply you with a specific answer (VBA CODE)

[nkhasu]

not sure i know how to do that...

[shg]

In the reply dialog, push the button with the paperclip, or scroll down to the Manage Attachments button.

[nkhasu]

i think i got it...here's a snapshot of my file. i've already combined the like numbers and left blank row between unlikes. does this help??

[shg]

Maybe like this:

Please Login or Register  to view this content.

[nkhasu]

thanks! i tried to use it but macros will not since there isn't a signature. i've never done this before do i just disable the security and go ahead and use???

[rwgrietveld]

It's simple.

Open your own sheet. No password required. Select any cell in your sheet. Press Alt-F11.

You'll see the VBA environment.
Double click the sheetname (left). Will look like Sheet1 (Sheet1).
Your cursor is now blinking in the edit box.
This is where your paste the code of shg.
After pasting, place your curson just after sub x() and press F5.
Hopefully the result is what you require.

[nkhasu]

i must not be having good luck with this. i tried and it just sits on one line and 'runs' but nothing is being 'organized'. hmmmm

[rwgrietveld]

Well, at least it runs now. It might not seem much, but it is a step forward!

Maybe your original data look a bit different. shg provided code that works specifically with the data you provided. I've tried manipulating the data and for me it works.

Please copy the code in the data you have provided (BOOK2.xls) and try for yourself. If you break the code (Ctrl+Break), at what line is the code stopping (becomes yellow)?

[nkhasu]

wow!! i see that it worked in book2! that's great! i'm trying again on my spreadsheet.

i selected all...then alt f11, entered the 'formula', then put cursor at top

[nkhasu]

and hit F5...when i do it just makes the screen jump and that's it...hmmmm

should i hit alt f11 again and then alt f8??

[nkhasu]

THANK YOU!!! i owe yall so much!! it worked. i had to give it quite a bit of time but it worked!!!! i'm not going to be covered in work this weekend!! THANK YOU SO MUCH!!!

[shg]

Would please mark the thread as Solved?

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save