+ Reply to Thread
Results 1 to 5 of 5

Need help with macro to clean up a table of data

  1. #1
    Registered User
    Join Date
    03-21-2011
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    24

    Need help with macro to clean up a table of data

    You guys have been VERY helpful on things like this before. Need your help again, please!

    This is an Excel data dump out of SAGE. Tab1 is how it it comes. Tab 2 is how I am trying to reorg it. In column A, the first number is the SKU, then the following numbers in A are the Location, then a space, then a new item same set-up. I need location broke out into the 2nd column and the SKU in the 1st column and the remaining information following to the right. When the space appears in column A the totals to the right are sums and I do not need the at all.

    There are approx 250,000 lines of data in this table so doing by hand will get ugly.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Need help with macro to clean up a table of data

    I have seen a max of 2 LOC codes for each SKU. Are there chances of more?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    03-21-2011
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Need help with macro to clean up a table of data

    Actually, I have seen 4 and 5 locations on a single SKU.

  4. #4
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Need help with macro to clean up a table of data

    Give this a try

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  5. #5
    Registered User
    Join Date
    03-21-2011
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Need help with macro to clean up a table of data

    Mike,
    That worked great! Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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