I need to copy and paste values from my current worksheet into multiple new worksheets and then save those files as specific names. The way I need it to work is to copy all the rows that have the same value in column C into separate worksheets. So each file will only have the rows that have the same value in column C. And then save those files with specific names.
For example if I have a value in column C like "LS" I need to take all the rows with that value in it and copy those to a new file and then save that file name as "Daily Quote Report - LS". Then do the same for all the other values in column C. If there is no value in Column C I also need to copy those with the ones that have a value of "BC" into the same file but save that as "Daily Quote Report - BC". There could be on average about 8 different values in column C so there could be 8 files that need to be created.
Any ideas on how this can be done?