Error Checking in Excel
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
    13
    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
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    bump

Some videos you may like

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
  •