If I understand what you're saying, you've *inserted* a new Column B and C
to accept the parsed, separated data from Column A.
So now, just do what you previously did, and select your "whole" sheet, and
instead of sorting on Column A, just sort on Column B & C, and all the
associated data in the adjoining columns will follow.
And, there's really nothing that says that you must delete the new B & C.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"axlmastr" wrote in
message ...
@RagDyer
Thanks for the influencial info. I have just produced a test run of
you instructions line for line. I am at a slight impass. I need to
mention that I have data in cells across each row that one of these
part numbers represents. Basically, to save myself writing a database
in Access, I use the worksheet as a Bill Of Material. I have
structured column headings from A-M. Each part number has it's own
row, except for those that repeat due to their difference in
components. The easiest way I find to distinguish items with the same
Part Numbers but different components is by codes I add as suffixes. I
can sort the three columns using you method, though I still see the true
numbers in column B with the text in column C. How do I delete the
helper cells (as you suggest) and not lose the data (true numbers
and/or text) in them and still retain my original starter column with
respect to the resulting sort? Also how do I include the remaining
columns in the sort? Until now I selected the whole sheet and sorted
by Column A and it worked ok, but I really like the results you showed
me and would rather use your method if possible. Or can you tell me a
better way to enter the part numbers in order to sort more cleanly?
Thanks RagDyer
--
axlmastr
------------------------------------------------------------------------
axlmastr's Profile:
http://www.excelforum.com/member.php...o&userid=26880
View this thread: http://www.excelforum.com/showthread...hreadid=401136