Sorting a portion of a table? Really struggling

Hi jcolacino and welcome to the forum.

If what you have in mind can be done with the layout you have I am not aware of it. Assuming you are at a data entry stage would you consider an alternative layout to start with?

I believe you will find the proposed layout (attached) will lend itself to data entry and sorting on each field more easily. It also keeps all your data in a central location from which you can draw upon for more specialized work, layouts and navigable arrangements.

If the attached presents you with difficult navigation problems please let us know what those are. There might be remedy.

Follow-up.

I completely forgot about Pivot Tables. You can sort the part numbers within their categories with this.

Have a look at the attached. I've added a sheet with Pivot Table using the table I proposed in the above as the source. It also works somewhat with your original table, but I was unable to filter out the blanks.

Glad to hear progress. Keep us posted. Should you need further assistance with Pivot Table please come back. I am relatively new to them myself, but there are many PT experts here.


@ the offer. We are a free forum ... all volunteers. Thank you, but I must pass. I like "working" for free ............. so far. LOL