Hi All, I am new to VBA and have been combing through the message boards trying to find a solution to my problem but can't seem to get any of the options to work. I have 2 different worksheets ("Summary Table", "By Product Source") that both have the same column name "User" and the data has the same users as it is just a different granular view. I want to cycle through each user (on both sheets) and save a workbook with the username of that user,
So for example there are 10 different users and the output would be 10 different saved workbooks saved by the "User" in the column.
In addition, on the Summary Table, I have some metrics at the top that need to show the totals based on the filtered user. I have calculations in there to do this already so would just need to ensure those were update based on the filter. Alos have some conditional formatting I would want to carry over to the new workbook.
Any help here on the VBA needed would be greatly appreciated.
So for example there are 10 different users and the output would be 10 different saved workbooks saved by the "User" in the column.
In addition, on the Summary Table, I have some metrics at the top that need to show the totals based on the filtered user. I have calculations in there to do this already so would just need to ensure those were update based on the filter. Alos have some conditional formatting I would want to carry over to the new workbook.
Any help here on the VBA needed would be greatly appreciated.