Forum Discussion
Need help with selecting specific worksheets and copy data based on user input.
Hi Everyone! I have the following use case. I have an excel workbook with multiple unformatted(No Tables) worksheets. The target sheets contains data below column headers(namely Date, ID, Name, Loca...
Create a new sheet. Move all data from the sheets in this new sheet. Delete the old sheets.
Format as table.
Filter the table:
- Filter
- Slicer
- FILTER()
- Or work with a pivot table.