Dear Sirs,
My project is to Create a new sheet for every unique value in selected filtered column.
The project is divided in 2 steps
1.Creating userform to specify data column for filtering and extraction .
This steps has been completed by the help from Variatus in the following link
https://www.teachexcel.com/talk/3075/how-to-create-userform-to-specify-data-column-for-filtering-and-extraction#discuss_section_3077.
The code is written in the attached TXL 181005 Purchase Report.xlsm file and the data file is Purchased report.xlsx
By clicking the green button on the lone Dashboard tab. The program will ask us to specify a file which must be similar in structure to the attached Purchased report.xlsx data file. It will then read the contents of that file into the drop-downs of the user form that opens
2. Based on the specifying data column for filtering and extraction in step 1 : I need further help in creating macro code to create a new sheet for every Unique value in selected filltered Column
The data file will be opened, read and closed - never modified in any way. the report is creating in a third workbook for the output.
The code will copy all rows with the same value in the selected filtered column of the range to a new worksheet in a third workbook for the output. It will do this for every unique value.The sheets will be named after the Unique value.
if the user selects PO Date = 2018-06-28 in the attached Purchase report.xlsx file,
The Code will create third workbook for the output with 6 sheets below in
- Office Supplies and Printing
- Outsource dan Service
- ATK
- Machine Part
- Maintenance
- IT
Looking forward to having your further advice in this regards.
Many thanks and best regards
Arsil Hadjar