gssachin
Board Regular
- Joined
- Nov 14, 2013
- Messages
- 155
Hi,
I have one salary master sheet containing 5000 rows, 50 columns, I want to get filter data on basis of column "Location" and paste it in separate sheet in same workbook but in different worksheet and rename the sheet as that location name also that single sheet to be copy new workbook and rename as "Mar22_"Location Name"
So once I run the macro my master sheet will add sheets as per location wise and same time it will save separately in my location (i.e. C:\Mar 22 Salary)
Thanks in advance
I have one salary master sheet containing 5000 rows, 50 columns, I want to get filter data on basis of column "Location" and paste it in separate sheet in same workbook but in different worksheet and rename the sheet as that location name also that single sheet to be copy new workbook and rename as "Mar22_"Location Name"
So once I run the macro my master sheet will add sheets as per location wise and same time it will save separately in my location (i.e. C:\Mar 22 Salary)
Thanks in advance