Results 1 to 2 of 2

Thread: VBA

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: May:2013
    Location:
    Posts: 1

    VBA

    ,

    . , - "MAIN" "DATA". . "Refresh", "DATA", "A" "A" "MAIN" "DATA" "MAIN", "MAIN" -.


  2. #2
    The point of no return ifch0's Avatar
    Join Date: Jun:2007
    Location:
    Posts: 3,678
    :

    Sheet "Data", B, , "Main" . B2 "IF(ISNA(VLOOKUP(A2; Main!$A:$A; 1; FALSE)); "No"; "Yes")
    , - B, "Yes"- .
    , Advanced Filter (+ Copy) .
    ( , Paste- , -, ).
    Main / A , 1 Paste- .
    Macros.
    , , , .
    : ( ) - (); (..) - (..).
    -----! , ...

Posting Permissions

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

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |