Dear Experts,
I have 2 workbooks. Workbook (Data) has got 2 sheets with data (Warehouse1 and Warehouse2). Another worksheet(Stock) will have userform with a text box and Listbox with 2 Tabs. When click on cell A1 in workbook named "Stock Check", userform will open with textbox populated with cell A1 data and list box to be filled with all datas related to cell A1 in Tab1 and Tab2.
For Example, Cell A1 of workbook "Stock" is Shirt S. when we click on Shirt S, excel checks workbook named "Data" and bring the results of All Shirts in Warehouse1 to the listbox of Tab1. Similarly Tab2 with Warehouse2 data.
Is this possible ?
I have 2 workbooks. Workbook (Data) has got 2 sheets with data (Warehouse1 and Warehouse2). Another worksheet(Stock) will have userform with a text box and Listbox with 2 Tabs. When click on cell A1 in workbook named "Stock Check", userform will open with textbox populated with cell A1 data and list box to be filled with all datas related to cell A1 in Tab1 and Tab2.
For Example, Cell A1 of workbook "Stock" is Shirt S. when we click on Shirt S, excel checks workbook named "Data" and bring the results of All Shirts in Warehouse1 to the listbox of Tab1. Similarly Tab2 with Warehouse2 data.
Is this possible ?