G
Guest
Based on data entered (ID_Location) I need to extract information from
another worksheet. I have used VLookup successfully to extract the first
occurrance of the information.
VMM_Sig_Name = Application.WorksheetFunction.VLookup(Range(ID_Location),
VMM_Workbook.Worksheets(ShortVMM_FileName).Range("B62000"), 3, False)
I do know the number of times the "ID" shows up in the other worksheet.
Num_Of_IDs_In_VMM =
Application.WorksheetFunction.CountIf(VMM_Workbook.Worksheets(ShortVMM_FileName).Range("B6:B2000"), myID)
What is the best way to extract all the information? Use multiple VLookups?
Obtain the address, in the other worksheet, of the first occurrance then
conduct a copy and paste?
Example:
ID to lookup, fisrt run = 100h, second run = 025h,
Lookup Worksheet information:
Column B Column D Column P
000h A Desk
000h B Chair
000h C Computer
100h A Apple
100h B Orange
100h C Pear
100h D Peach
100h E Grape
025h A Tomato
025h B Beans
025h C Cucumber
025h D Pepper
Thanks
another worksheet. I have used VLookup successfully to extract the first
occurrance of the information.
VMM_Sig_Name = Application.WorksheetFunction.VLookup(Range(ID_Location),
VMM_Workbook.Worksheets(ShortVMM_FileName).Range("B62000"), 3, False)
I do know the number of times the "ID" shows up in the other worksheet.
Num_Of_IDs_In_VMM =
Application.WorksheetFunction.CountIf(VMM_Workbook.Worksheets(ShortVMM_FileName).Range("B6:B2000"), myID)
What is the best way to extract all the information? Use multiple VLookups?
Obtain the address, in the other worksheet, of the first occurrance then
conduct a copy and paste?
Example:
ID to lookup, fisrt run = 100h, second run = 025h,
Lookup Worksheet information:
Column B Column D Column P
000h A Desk
000h B Chair
000h C Computer
100h A Apple
100h B Orange
100h C Pear
100h D Peach
100h E Grape
025h A Tomato
025h B Beans
025h C Cucumber
025h D Pepper
Thanks