If you have data in one Excel worksheet, can you output a subset of it to another sheet in the same workbook, based on criteria set on another sheet?
For example:
How should I go about this? What’s the general approach?
For example:
- Criteria sheet: User selects various values
- Data sheet: All the raw data, refreshed periodically, could be up to 50,000 rows x 40 columns
- Output sheet: A subset of data e.g. 50 rows x 6 columns with additional calculated columns, properly formatted
How should I go about this? What’s the general approach?