I am working with an excel file that contains nearly 200 invoices in one work sheet(each invoice occupies the same amount of space/ranges). I want to have a macro that takes the first 3 letters of a company name within B2 and create a new worksheet with that name then copy the invoice to that worksheet. I'm at a complete loss at how to do that.
Thanks for the help in advance.