Hi everyone,
I have two Workbooks. Overview Workbook1 which contains Cost types (Travel, Transport costs..etc) and Combo box (List) with months from January till December .
The other Workbook2 contains detailed information about costs for all months from January till December in seperate Sheets. Ex. Sheet January contains Cost types in Column A and amount in Column B.
In overview Workbook1 I want to select month(i.e Jan) from Combo box(List) and get updated information for appropriate month.
I know how to retrieve data from another workbook with Vlookup but do not know how it works with Combobox or List.
Is it possible to solve it without VBA?
Thanks,
Beck
I have two Workbooks. Overview Workbook1 which contains Cost types (Travel, Transport costs..etc) and Combo box (List) with months from January till December .
The other Workbook2 contains detailed information about costs for all months from January till December in seperate Sheets. Ex. Sheet January contains Cost types in Column A and amount in Column B.
In overview Workbook1 I want to select month(i.e Jan) from Combo box(List) and get updated information for appropriate month.
I know how to retrieve data from another workbook with Vlookup but do not know how it works with Combobox or List.
Is it possible to solve it without VBA?
Thanks,
Beck
