Hi All, Looking some assistance in filtering:
- First, I have copied the unique state values to copiedSheet (completed).
- Then using the values in the copiedsheet, i have apply the filter by state
- copy the results to the new workbook with the sheet name corresponding to each states (“AL”, NY", NJ" etc…).
I have attached my xaml and sample workbook for your referrence.