Hello everyone,
I have a master workbook with personnel list. There are lots of different departments in the company. The department info is stored at Colomn C. And I want to copy personnels (rows) from spesific departments to another Workbook without any spaces and null rows between them. 30 different workbooks which include 30 different groups of departments. I also want these different workbooks have the same header, which is 6 rows of info stored in another sheet at master workbook. So the personnel list should start from row 7.
I hope I made myself clear. Thank you very much.
Bookmarks