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.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option
David Miller (dlmille)
Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.