Hello !
I would like to ask for support in creating simple macro that would actually do few things:
1. We have two columns Employee Class and Employee name.
-In (Sheet1) Basing on "employee class" column, every employee got his class i would like to get all the records from "employee name" column that are for example "Class 1" in to desired cell in other sheet that also do have employee class column.
- In destination cell (Sheet2) there is Class codes column with unique values that are available for company.
- I need to separate people from Sheet1 to Sheet2 basing on class codes so it would looks like:
Class code Employee
62 Tom, Johnny, Melisa
Is there any way to do that efficiently ?
Thanks in advance !
Bookmarks