VBA to Take List of names and place on specific sheets.... Hard!!!

I currently have a macro built that takes the Main Sheet and makes a copy of it for each Department Name/#. I then need the Employee ID # and Full Name populated in column A and B of each Department sheet. I highlighted the data on the Data tab that needs to be moved for one example onto the Cashier 6 tab.

If anyone has questions please let me know. This seems like an experienced coder may be needed.

This is amazing. My last step in this worksheet is to hide the rows not populated on each departments sheet. I would assume the code would be to hide any row from 3-100 if cell in column A is blank.

Is this hard to do?

Daffodil11,

Check out the posting I just did in the Macro/VBA section called "Hiding Rows if cell is blank". Given you have created the other coding for my worksheet, I think you may be the best candidate to be able to get this completed. Let me know your thoughts.

Thanks!