Hello There,
I am looking towards making a drop-down list on a cell which is based on a external master file
The 2 files attached are:
1. Master file (File Master Data.xlsx)
2. Invoice data entry (File Invoice.xlsm)
File 1 consists of worksheet (Master) where master data is defined and (Setup) where the columns needed in the drop-down list is defined.
File 2 consists of a Table, and the drop-down list defined is on column 'Amount From File Master Data'. On clicking the drop-down list, it should refer File 1 worksheet (Setup) to collect column names, then go to worksheet (Master) get data from the columns and display the multiple columns drop-down list and return sum of amounts value on the cell.
I have explained the same in the 2 excel files
Never done this before and look forward for your help in achieving this.
Thanks & regards
Don
Based on File 1's worksheet (Setup), it should pick up the columnsThis drop down list should
I am looking towards making a drop-down list on a cell which is based on a external master file
The 2 files attached are:
1. Master file (File Master Data.xlsx)
2. Invoice data entry (File Invoice.xlsm)
File 1 consists of worksheet (Master) where master data is defined and (Setup) where the columns needed in the drop-down list is defined.
File 2 consists of a Table, and the drop-down list defined is on column 'Amount From File Master Data'. On clicking the drop-down list, it should refer File 1 worksheet (Setup) to collect column names, then go to worksheet (Master) get data from the columns and display the multiple columns drop-down list and return sum of amounts value on the cell.
I have explained the same in the 2 excel files
Never done this before and look forward for your help in achieving this.
Thanks & regards
Don
Based on File 1's worksheet (Setup), it should pick up the columnsThis drop down list should