+ Reply to Thread
Results 1 to 3 of 3

Excel Sort Error

Hybrid View

  1. #1
    Registered User
    Join Date
    10-21-2014
    Location
    usa
    MS-Off Ver
    excel 2013
    Posts
    4

    Excel Sort Error

    Hello again,

    I use excel to upload mass amount of product to third party listing platforms, about 3 or 4 excel files a day with anywhere from 100 to 1500 items. I have to do a lot of sorting to confirm that the data was entered properly from our receivers. However, in all my sorting sometimes it doesn't "expand the selection" and I am finding out that I have listed 1,000's of items with the wrong information or pictures. It's becoming a huge problem, and I wanted to know if anyone else was dealing with this same issue and if there is way to fix it or maybe a work around.
    Last edited by ntc321; 02-10-2015 at 12:45 PM.

  2. #2
    Registered User
    Join Date
    10-21-2014
    Location
    usa
    MS-Off Ver
    excel 2013
    Posts
    4

    Re: Excel Sort Error

    Update:

    I am currently trying a bunch of trial and error to see if I can find a common denominator and I have noticed that the sorting error happens after I am sorting a vlookup that I have performed(I do paste the values in place of the vlookup formal). Any one else having this problem and a way to fix or work around it. I have confirmed about 4,000 of my 56,000 items live on our eCommerce platforms are wrong. That is a little over 7% error rate which just seams insanely high for excel.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Excel Sort Error

    Before sorting do a Shift/End Home to "grab" all the data, then do the sort
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Sort Macro Run-time error '1004': Application/Object-defined error.
    By sam1212 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2014, 10:05 AM
  2. [SOLVED] [SOLVED]VBA Sort Error-runtime error 2147417848(80010108)
    By sureshtrb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-30-2014, 12:59 PM
  3. Replies: 4
    Last Post: 11-20-2012, 06:00 PM
  4. Replies: 2
    Last Post: 07-28-2010, 04:53 AM
  5. [SOLVED] Excel VBA error-recorded a macro to sort
    By Leena in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2005, 11:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1