Results 1 to 3 of 3

[Macro] Empty value rows deleting

Threaded View

testadimissile [Macro] Empty value rows... 10-07-2017, 08:45 AM
AlphaFrog Re: [Macro] Empty value rows... 10-08-2017, 03:31 AM
testadimissile Re: [Macro] Empty value rows... 10-09-2017, 03:58 AM
  1. #1
    Registered User
    Join Date
    08-20-2014
    Location
    Ravenna, Italy
    MS-Off Ver
    2010
    Posts
    51

    [Macro] Empty value rows deleting

    Good morning guys (in italy is morning),

    i'm attaching you the .xls file for your tests.

    Here is the problem. In the file u can find several sheets containing different kind of items.

    The purpose of the MACRO is to copy and paste all items into "TOTALE" sheet that is the final output sheet.

    The problem is that if the item have 0 quantity, the macro should delete the row in the output sheet.

    There is something to do that, but it's not working and i don't know why.

    Column F is for the quantity.

    Thank you to everyone in advance.
    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. Macro for deleting everything after last row & all empty rows
    By nwood29 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2017, 08:48 PM
  2. [SOLVED] Macro code for deleting empty rows in the output worksheet
    By macrolearnerkk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-07-2015, 02:06 PM
  3. Code/Macro for deleting empty columns and rows.
    By gautamacharya in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-09-2014, 01:49 PM
  4. [SOLVED] Deleting empty rows in excel using macro
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2013, 02:40 AM
  5. Deleting empty rows if specific cell in row is empty
    By csynic in forum Excel General
    Replies: 0
    Last Post: 07-06-2011, 01:43 AM
  6. Autofilter/delete empty rows is deleting non-empty rows!
    By oOarthurOo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2010, 12:31 PM
  7. Deleting empty rows
    By test1986 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2006, 07:12 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