Results 1 to 9 of 9

Splits Data base on Column Criteria

Threaded View

  1. #7
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Splits Data base on Column Criteria

    Hi Mark

    I have this 99% resolved...have a couple of issues.

    In the Schenker Customer list.xlsx there are items that have the same Sheet Name but appear to be not linked together, namely:

    DE00137842 Kelsterbach SCHENKER DEUTSCHLAND AG LANGER KORNWEG 34E Kelsterbach 65451
    DE21806 Kelsterbach SCHENKER DEUTSCHLAND AG LANGER KORNWEG 34E Kelsterbach 65451

    and

    DE17070 Munich SCHENKER DEUTSCHLAND AG CARGO TERMINAL MODUL A 4 Munich 85356
    DE39652 Munich SCHENKER DEUTSCHLAND AG PAUL-HENRI-SPAAK-STR , TOR 21 8 Munich 81829

    and

    DE11754 Stuttgart SCHENKER DEUTSCHLAND AG LUFTFRACHTZENTRUM Stuttgart 70629
    De00123576 Stuttgart SCHENKER (MESSE) DEUTSCHLAND AG MESSEPIAZZA Stuttgart 70629

    Shoud they be? If not they will require DIFFERENT Sheet Names.
    Last edited by jaslake; 01-08-2014 at 10:42 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Autonumbering Base on other Column Data
    By ajdluistro in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2013, 05:24 AM
  2. Replies: 2
    Last Post: 01-29-2013, 02:46 PM
  3. how to transform data from row-base to column-base
    By fei2010 in forum Excel General
    Replies: 3
    Last Post: 11-23-2012, 12:17 AM
  4. Copying Data base on Criteria
    By jim2012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2012, 11:45 AM
  5. Sort Data Base By Column
    By travelersway in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-21-2006, 06:25 PM

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