Hi All,
I need help with data to be extracted from one sheet to another. Following is the requirement and I'm attached excel file for better understanding:
- There are two tabs "Raw data" and "Forms"
- In Forms tab, will have a Multiple selection list dropdown buttons
- Selection can be either / or /and
- Once Generate button is clicked, data from "Raw Data" to be extracted in from C20 and below
- Data should display on which columns are colored in Purple in "Raw data" header
- Download of generated data to be exportable to new excel
- Create a form to update/Append new data should be able to append in the raw data (could also be a existing record) x
I need help with data to be extracted from one sheet to another. Following is the requirement and I'm attached excel file for better understanding:
- There are two tabs "Raw data" and "Forms"
- In Forms tab, will have a Multiple selection list dropdown buttons
- Selection can be either / or /and
- Once Generate button is clicked, data from "Raw Data" to be extracted in from C20 and below
- Data should display on which columns are colored in Purple in "Raw data" header
- Download of generated data to be exportable to new excel
- Create a form to update/Append new data should be able to append in the raw data (could also be a existing record) x