I have a spreadsheet that contains a report of which department has an item entered.
what I want to accomplish is to move the individual 'department' data to thier own sheets. I have one case where I will have 4 different departments combind on one sheet, the remaining will occupy thier own sheets.
How can i create a macro that will look down this column containing the department names and move thier data over to a new sheet, all within the same workbook?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!