Could someone help me with a macro to:
- copy the range of cells (A5:AA20) on sheet2 down to the last data entry on sheet2
- copy row 7 on sheet3 and insert copied cells to row 8 on sheet3
- copy row 25 on sheet3 and insert copied cells to row 26 on sheet3
What I am doing is adding employees on sheet1, starting with "employee1", and having the data on sheets 2 and 3 copied down for each additional employee. Basically I'm looking for an "Add Employee" macro that copies the required ranges as defined above as I...well, add employees on sheet1. Hope this makes sense. Thanks
- copy the range of cells (A5:AA20) on sheet2 down to the last data entry on sheet2
- copy row 7 on sheet3 and insert copied cells to row 8 on sheet3
- copy row 25 on sheet3 and insert copied cells to row 26 on sheet3
What I am doing is adding employees on sheet1, starting with "employee1", and having the data on sheets 2 and 3 copied down for each additional employee. Basically I'm looking for an "Add Employee" macro that copies the required ranges as defined above as I...well, add employees on sheet1. Hope this makes sense. Thanks
