Results 1 to 7 of 7
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Condition very strong... (2000 sr 1)

    Since the import routine (FIPO) writes data to different worksheets, it is impossible to include the check on problems in this routine. You will have to perform the check after the import is complete.

    The attached code will check the active sheet. It can easily be modified to check a series of worksheets.

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

    Condition very strong... (2000 sr 1)

    Thsi sheet contain a list of Holding and SubHolding.
    Ths Holding is identify from the value 01 ad 99 into column J.
    Into column B is present for each block of Society an ID, is the same for group.
    Into column L, M, N, and O are present many value. (are present only if a Group of Socity ha a problem with they account.)
    Condition:
    If in the column J is present 01 or 99 controll if all subholing not have poroblem into column L, M, N, and O, put into column R the value "OK" else go to the next line of macro(attached).
    I have have colorized the condition if the condition is for "OK" value, in the ine 15 to 22.

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

    Re: Condition very strong... (2000 sr 1)

    Great code!
    Hans, but you have maked a sort into column B, praphs, you want to be sure for rorder?

    In other case all sheet are already ordered from B. I can comment this this line or is important for the rest of macro

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

    Re: Condition very strong... (2000 sr 1)

    If the data are already sorted on column B, you can remove or comment out the line that sorts the data from my code.

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

    Re: Condition very strong... (2000 sr 1)

    ... You have undesrtand me very fast!

    My idea for the future:

    Create a section into Excel forum named:

    "Sal21- Excel"

    Language: Sal21

    Free translation for international user:

    Hans

    Administrator:

    Hans


    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> <img src=/S/fanfare.gif border=0 alt=fanfare width=31 height=23>

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

    Re: Condition very strong... (2000 sr 1)

    Thank, but no thanks... <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

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

    Re: Condition very strong... (2000 sr 1)

    ... My post is only to get the day with a smile!

Posting Permissions

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