Every day I work on a workbook which have huge data. My workbook have 4 sheets. These sheet names will be changed everytime. they are not static. But the first two words will be same. I dont need any action need to be taken on the first sheet. On the other three sheets in workbook I need to apply a filter on one column and copy that data to new sheet and save it. Then I need the filter to be transposed and save the data to another sheet. This needs to be done for other 3 sheets in the workbook. One more condition is the filter column will change based on the sheet. Can anyone help me to build a macro for this? That will be great.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Macro to filter data with sheet name and copy to another sheet based on the criteria
- Thread starter mshaik224
- Start date
Similar threads
- Question
- Question
- Solved
