Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    WHY NOT ADD UP THE LINE? (2000 sr 1)

    ... this sheet work 50% !!!!!!!!

    This macro controll the many line from clomun S in the sheet L00785_TOTALE and if the condition is ok delete two line and add one of this line deleted in the sheet L0785_PAGATI...

    My problem:

    i dont understant why the macro not add the line in the sheet L0785_PAGATI to the existing other line????????????????

    Sorry for dimensionof the file

    http://www.gssitaly.com/test_pagati.zip

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: WHY NOT ADD UP THE LINE? (2000 sr 1)

    The problem is that the macro always starts copying to row 7 on L0785_PAGATI, because of the line

    pr = 7

    at the beginning of the macro. This is only correct if L0785_PAGATI has not been filled yet. Replace that line by

    pr = Worksheets("L0785_PAGATI").Range("A65536").End(xlU p).Row + 1

    This moves up from the bottom of the spreadsheet until a non-blank cell is encountered. The first blank row is the one below that.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: WHY NOT ADD UP THE LINE? (2000 sr 1)

    ... naturally IT WORK very well

    Dubt, but with your experince, before to run this macro i make order the line whit another macro (if you see ORD_ASS it make near the line to delete if exist the condition) have you another way without to order macro?... I hope you sure have understand the concetp of my macro....

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: WHY NOT ADD UP THE LINE? (2000 sr 1)

    It would be possible to avoid sorting the data, but the macro PAGATI would become more complicated. You would have to look at the value of C/C (in column D) in each row, then do a downward search for the same value, if found keep track of which row contains 36, etc. Unless sorting the data is very inconvenient, I would keep it.

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: WHY NOT ADD UP THE LINE? (2000 sr 1)

    Tks, as usual the explain, i use the my old macro with your mofify, important is that work fine...
    Hans, sorry for my english but i sure you understad me on the fly with any language also with this alph italian and english...
    In this case the code in the my macro it is more clearly of my words in English, compliments for this.
    Form this little things identify a good expert acknowledges
    I hope that this message is read from many persons in this forum.

    Salvatore

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •