Results 1 to 4 of 4

Deleting Repeated Lines of Data

Threaded View

  1. #1
    Registered User
    Join Date
    06-14-2012
    Location
    Ames, Iowa
    MS-Off Ver
    Excel 2010
    Posts
    50

    Deleting Repeated Lines of Data

    I get data imported into an excel spreadsheet. Its not very conducive because I have around 450 pages of data that all have the same header at the top of the page with information I want removed. Is there any code that will help me remove all the repeated lines that I don't need? See attached spreadsheet, the highlighted items are what I would need to be removed. Basically I'm wanting to delete 8 rows, keep the next 48, delete the next 8, keep the next 48, and repeat.
    Thanks in advance for any advice or help you can give me.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 10-09-2015, 09:19 AM
  2. Replies: 7
    Last Post: 03-10-2015, 09:30 AM
  3. Deleting Repeating Lines of Data
    By ISUCyclones in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2014, 12:26 PM
  4. [SOLVED] When filtering repeated data, leaving the title(header) alone without deleting it
    By exlgh91 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2013, 12:58 PM
  5. Replies: 14
    Last Post: 05-10-2013, 03:27 PM
  6. Deleting Repeated Data
    By KHaberstroh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-18-2007, 11:46 AM
  7. Deleting cells with repeated data
    By petevang in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2005, 06:35 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