shahzeb123
Board Regular
- Joined
- Jul 29, 2021
- Messages
- 61
- Office Version
- 2016
- Platform
- Windows
Hello,
I would like to ask that i have data with rows over 22000 , so what is want is i will filter the data by branch wise, then i need button for,
copy all the visible data only i.e only filtered data into new workbook and with all formatting and also do not show the button in other sheet,
then change the file name of new workbook by which the data was filtered i.e the branch name,
and then ask me the destination by pop up window where to save it
I would like to ask that i have data with rows over 22000 , so what is want is i will filter the data by branch wise, then i need button for,
copy all the visible data only i.e only filtered data into new workbook and with all formatting and also do not show the button in other sheet,
then change the file name of new workbook by which the data was filtered i.e the branch name,
and then ask me the destination by pop up window where to save it