Excel spreadsheet with script/formula
Budget: $30 – $250 AUD
I am looking for a freelancer to create an Excel spreadsheet with a script/formula to perform calculations.
Specific tasks:
Develop a script/formula where we can create a tab and fill it with values from drop down menu.
The drop down list should be searchable and once selected the whole source row should be copied.
Results in the dropdown list should have the sheet name where it was found and other cells from this row.
The list should be sorted; i.e. most recent items on top of the list.
More details to be discussed.
Specific tasks:
Develop a script/formula where we can create a tab and fill it with values from drop down menu.
The drop down list should be searchable and once selected the whole source row should be copied.
Results in the dropdown list should have the sheet name where it was found and other cells from this row.
The list should be sorted; i.e. most recent items on top of the list.
More details to be discussed.