I have an Excel file with conditional formatting and sparkline charts. I want to filter a column by one value, copy to new workbook, and save as new file with filename of filtered value (or overwrite an existing file) then repeat. I'm looking for an automated solution to the problem.
In the sample file uploaded below, the goal would be to have 32 separate files named by team (column F) and only each team's data in each separate file. Conditional formatting and sparklines still present is required. I would also still want the master file in tact as well.
I provided a sample master file and a team output file (filename preferred: [login to view URL])
Let me know projected hours and rate. Thanks.
Sorry, but request is slightly different but hoping similar effort and pricing. Really need to know if someone can automate the VBA code already created. I'm updating AutoFilter for every value, but there has to be a better way. Just don't have the time to research it.