VBA Question for V-Look Up from Another Sheet

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: VBA Question for V-Look Up from Another Sheet

  1. #1
    New Member
    Join Date
    Nov 2017
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA Question for V-Look Up from Another Sheet

     
    Hi Guys,

    I am trying to bring the following V Look Up formula into Column A on a sheet called "AIC Data".

    =VLOOKUP(V2,'Key Card'!D:E,2,0)

    The V Look Up is coming from a data source on another Sheet "Key Card".

    Can anyone assist with the proper VBA?

    So far I have the following below but the formula isn't coming down the entire Column A of the data source.



    Sub FormatData()


    '
    Application.ScreenUpdating = False

    Sheets("AIC Data").Select
    Range("A2").Select
    Application.CutCopyMode = False
    ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[21],'Key Card'!C4:C5,2,false)"
    Range("V2").Select
    Selection.Copy
    Range("V2").Select
    Selection.End(xlDown).Select
    ActiveCell.Offset(0, -21).Select
    Range("V2").Select
    Selection.CurrentRegion.Select
    Range("V2").Select
    Range(Selection, Selection.End(xlToRight)).Select
    Range(Selection, Selection.End(xlDown)).Select
    Range(Selection, Selection.End(xlDown)).Select

    With ActiveWorkbook.Worksheets("AIC Data").AutoFilter.Sort
    .Header = xlYes
    .MatchCase = False
    .Orientation = xlTopToBottom
    .SortMethod = xlPinYin
    .Apply
    End With

    Thank you.

  2. #2
    New Member
    Join Date
    Nov 2017
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA Question for V-Look Up from Another Sheet

      
    bump

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com