+ Reply to Thread
Results 1 to 3 of 3

Ignore - wrong file uploaded

  1. #1
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Florida
    MS-Off Ver
    Home -Excel 2007, Work 2016
    Posts
    254

    Ignore - wrong file uploaded

    Wrong file uploaded
    Correct file has example in it
    Attached Files Attached Files
    Last edited by ILoveStMartin; 03-15-2016 at 01:07 PM. Reason: wrong field uploaded

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Ignore - wrong file uploaded

    Do you really want to delete the rows you're getting rid of or would you prefer to hide them?

  3. #3
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Ignore - wrong file uploaded

    If you're cool with deleting the 'in between' rows, the procedure below worked for me. Please mind my note on the sixth line of code to change the value 26 to the row number of your first vendor entry. The 26 was based off of the sample you posted.

    Please Login or Register  to view this content.

+ 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. Replies: 8
    Last Post: 01-10-2016, 02:03 AM
  2. Macro VBA - Remove empty rows and columns with total deleted in msg
    By SmurofNeves in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-25-2015, 06:17 AM
  3. Macro to total values based on vendor criteria, delete rows & continue on
    By Tomtherom in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-16-2015, 04:52 PM
  4. Replies: 1
    Last Post: 05-13-2015, 12:52 PM
  5. Last 12 weeks total from rows not columns
    By flapface in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 10-14-2014, 09:29 AM
  6. Need: Total Values for Duplicate Entries, Do Not Remove Rows
    By esmithqg in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-23-2013, 02:29 AM
  7. [SOLVED] Macro to insert blank rows so that the total number of rows with data is equal to 1021
    By nsm1411 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-07-2013, 10:25 AM

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