fudgephish
New Member
- Joined
- Jan 23, 2014
- Messages
- 1
HI,
I'm trying to transfer each record in a consolitated table (ie: EMPLOYEE SUMMARY) into multiple individual worksheets (currently named 1-70, but i'd also like to change sheet name into EMPLOYEE ID) so that if i needed to edit employee information, i can go to that specific employee worksheet and view/update from there.
I tried to create a macro that copies and pastes each column value (ie: A1: Employee ID, B1: Name...) in the employee record to the target cells in the destination worksheet, but could not get the macro to then move to record 2 and transfer that to worksheet 2.
any suggestions to make the macro to loop?
I'm trying to transfer each record in a consolitated table (ie: EMPLOYEE SUMMARY) into multiple individual worksheets (currently named 1-70, but i'd also like to change sheet name into EMPLOYEE ID) so that if i needed to edit employee information, i can go to that specific employee worksheet and view/update from there.
I tried to create a macro that copies and pastes each column value (ie: A1: Employee ID, B1: Name...) in the employee record to the target cells in the destination worksheet, but could not get the macro to then move to record 2 and transfer that to worksheet 2.
any suggestions to make the macro to loop?
