To any one who is an expert at macros in excel, I was wondering if you could help me out. I am trying to use 2 sheets to run a vlookup that will look up a customer id # and return the corresponding month associated with booking that customer from the second workbook. They are both tables. So basically I just need to look up CustomerID from sheet 1 in sheet 2 and then paste the value of the month from sheet 2 into sheet 1. This is what I have so far. We run it every month and I would like to have a quicker process if at all possible. Thanks!
Sub Vlookup()
Dim mylookupvalue As String Dim myfirstcolumn As Long Dim mylastcolumn As Long Dim mycolumnindex As Long Dim myfirstrow As Long Dim mylastrow As Long Dim myvlookupresult As Long
Dim previousmonth As Range
mylookupvalue = "CustID" myfirstcolumn = 2 mylastcolumn = 15 mycolumnindex = 11 myfirstrow = 1 mylastrow = 500
With Worksheets("priormonth") Set mytablearray = .Range(.Cells(myfirstrow, myfirstcolumn), .Cells(mylastrow, mylastcolumn)) End With
myvlookupresult = WorksheetFunction.Vlookup("CustID", sheet2, 11, False)
End Sub
corpfincorpcredit, bummer your thread hasn't had a response yet. Maybe one of these threads could point you in the right direction:
Hope that helps.
Dolor sed debitis quas libero est. Consequuntur consequatur exercitationem et et. Quo veniam nostrum illo eveniet. Aut ab natus id odio quisquam.
Praesentium similique autem et rerum. Molestiae rerum nulla optio omnis est alias quidem id. Consectetur est totam ad beatae maxime. Ex error ea sit molestias corporis aut consequuntur. Maiores eligendi non voluptatem dolorum nam voluptates tempora.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...