Sorry for the belated reply, I dont get to spend alot of time going
through the newsgroup (only when I have a problem 🙂
I had a similar problem sorting in Excel when I was trying to do the
same thing as you... extract the BOM. I got so frustrated, that I ended
up putting the data into an array in code and sorting the array. Now,
before I get flamed for telling you to do it this way, let me make a
statement. If there is an available method or operation that you can
have the application accomplish, as opposed to doing it yourself, you
should go that route. However, the sorting method I used, and the
amount of data I was sorting (under 200 items), the method I used was
perfectly acceptable to my standards of getting the job done. I am not
an Excel expert, nor do I want to become one, so I chose to handle the
problem the best way I saw fit to do so. Just letting you know other
ways to look at...
Dennis Helms
Phix wrote:
>
> This is kind of an Excel question but maybe one of you knows. I'm exporting
> my BOM to excel, which works fine. I'm having trouble sorting the worksheet.
> I'm trying to sort column "A" against a custom list that I made. The problem
> is, it ignores the list which I'm specifying. The strange thing is even in
> excel when I manually choose sort and pick my list, it will not work, but...
> I notice that if I double click in a cell, or click in the formula bar, or
> change a cell contents, then try to sort it works. I'm not sure if there is
> a hang up or if there is something I'm not doing correctly. I even tried
> recording the macro to sort from within excel and running it and it's the
> same story. Any ideas?
>
> Thanks a million.
> -phix
