Hello,
This is my first post as I'm new to VBA and trying to learn with some LinkedIn Learning Modules. I'm hoping to get some help here because piecing together all the elements is new to me. Essentially I have an employee roster and I need to populate an evaluation form for each employee on the list. From the Tab "Warhurst_Roster" which is the list of names and source data, I would love to pull in the manager's name (Column O), their Title (Column J) Employee ID (Column B), and Name (Column A which is a concatenation of G+H). That data needs to go into the Hourly Evaluation Form and I've got a snip to show it, but Employee name goes into Cell D2, Supervisor Name goes into F2, Title goes into D3 and Employee ID goes into F3. I'd then like the program to copy cell D2 or employee name and name the tab with the employee name. Then cycle to the next name until it runs out of data on Row 201.
I'm posting my (sad) first attempt at making/recording a macro. It could be helpful-ish or could be a good laugh for a pro. Anyways Snips are below and I'd covet any help here.
Thank you in Advance!
Zimbo
Bookmarks