+ Reply to Thread
Results 1 to 2 of 2

Split Rows into Sheets Based on Content

  1. #1
    Registered User
    Join Date
    06-18-2012
    Location
    The Internet
    MS-Off Ver
    Office 2007
    Posts
    6

    Split Rows into Sheets Based on Content

    I've got a large number of wireless network data lined up in rows, split up into columns as MAC Address, Street Address, SSID and RSSID with multiple entries per MAC address. I need to split up rows into sheets with only that MAC Address on it. Ideally, after that I need a way to take the most common [however many] networks and graph them, but that's a whole other forum post.

    So I've been trying to use JBeaucaire's code from his post, HERE, but the problem is a MAC address doesn't work as a sheet name, and I can't figure out what part of his code I need to remove to deal with that.

    Thanks for your help guys,
    Daniel

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,448

    Re: Split Rows into Sheets Based on Content

    Hi Daniel,

    I think his line of code that might be the problem is:

    Please Login or Register  to view this content.
    It looks like you can't put a colon in a sheet name so how about changing all colons to dashes?
    Try this in place of that line of code above and see if it works.

    Please Login or Register  to view this content.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say 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