'Need to filter all the unique values one by one in a auto filter and copy and paste all the different results in a separate workbook and save it

I have an file that has some set of names/users in a column which is repeated and this column with users is not static and it could be anywhere in sheet and also the users name will vary, But i want all the available users data from the workbook filtered individually one by one and i need to copy and paste all the users data pasted in a new workbook and i want that workbook named after the respective users name, I tried some things but nothing worked out, So please help me out guys, I have given below the example of the data(it got converted into an link) i have for your reference.

enter image description here

vba


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

How do I get the paragraph number of the currently selected paragraph in Microsoft Word into an AppleScript variable?

Retrieving custom property value from received mail using GetProperty (which was set using SetProperty in Outlook VBA)

VBA to copy a file from one directory to another

How to add icons to emails in Outllook?

I keep assigning a value to my variable but it stays empty

Check if a cell from a selected range is visible

Create table from data on a worksheet with specific name and add column

Using VBA to query a SQL Server table in Excel

How can I generate a "Social Golfer" matrix for worker seating arrangement?

How to stop scroll bar auto jump in vba

Delete a mailitem permanently in outlook

If IsEmpty then go to column A but in same row and extract that data

Fetch data from website table using vba

How can I use a for each loop on an array?

VBA - worksheet object is hidden