ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Create two sheets, filter data to each (https://www.excelbanter.com/excel-programming/427509-create-two-sheets-filter-data-each.html)

J.W. Aldridge

Create two sheets, filter data to each
 

Sheet X has data in A:H. (No headers)
For each row with data, column A will contain either "abc" or "def".

I need to create two sheets
1 - "ABC Group"
2 - "DEF Group"

Filter all rows with abc in A to sheet ABC Group.
Filter all rows with def in A to sheet DEF Group.
Delete the original sheet - SheetX






All times are GMT +1. The time now is 12:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com