RalphMHill
11-14-2013, 02:40 PM
I have a Workbook that I would like to use a Combo-box to Reference data in a different workbook, in a different sub-Folder.
Example:
Current Workbook Name: 'C:\Forms\[C-Form.xlsm
Data workbook Name: 'C:\Data Sets\[CustomerData.xlsx
Data for the Combo-box is located in 'C:\Data Sets\[CustomerData.xlsx]Customers' $B:$B
In addition How can I bring back additional Values based on the customers Selection from the Combo-box (C-Form.xlsm)? I was using Vlookup formulas
SAMPLE
"=VLOOKUP(R[-1]C,'C:\Forms\[CustomerData.xlsx]Customers'!C1:C26,2,FALSE)"
OR
"=VLOOKUP(L10,'C:\Forms\[CustomerData.xlsx]Customers'!$A:$Z,5,FALSE)
If the customer selects the Name: ABC Co. from the Combo Box located in Cell - L10 ('C:\Forms\[C-Form.xlsm]Sheet1') I can propagate the fields for L11 - L16 with information from 'C:\Forms\[CustomerData.xlsx]Customers' $B-$G
SAMPLE
B1 C1 D1 E1 F1 G1
Name Address City State Zip ID Number
ABC Co. 123 Main St AnyTown Ohio 12345 C-10034
123 Inc. 256 Smith Ave MyPlace Iowa 98765 C-10035
Your Assistance in this matter will be greatly appreciated.
Example:
Current Workbook Name: 'C:\Forms\[C-Form.xlsm
Data workbook Name: 'C:\Data Sets\[CustomerData.xlsx
Data for the Combo-box is located in 'C:\Data Sets\[CustomerData.xlsx]Customers' $B:$B
In addition How can I bring back additional Values based on the customers Selection from the Combo-box (C-Form.xlsm)? I was using Vlookup formulas
SAMPLE
"=VLOOKUP(R[-1]C,'C:\Forms\[CustomerData.xlsx]Customers'!C1:C26,2,FALSE)"
OR
"=VLOOKUP(L10,'C:\Forms\[CustomerData.xlsx]Customers'!$A:$Z,5,FALSE)
If the customer selects the Name: ABC Co. from the Combo Box located in Cell - L10 ('C:\Forms\[C-Form.xlsm]Sheet1') I can propagate the fields for L11 - L16 with information from 'C:\Forms\[CustomerData.xlsx]Customers' $B-$G
SAMPLE
B1 C1 D1 E1 F1 G1
Name Address City State Zip ID Number
ABC Co. 123 Main St AnyTown Ohio 12345 C-10034
123 Inc. 256 Smith Ave MyPlace Iowa 98765 C-10035
Your Assistance in this matter will be greatly appreciated.