I'm sorry if this has already been answered somewhere else, I was having difficulty figuring out how to apply other answers to my situation.
I appreciate any help!
So I was able to paste link columns from the course list in order to generate it into the training log, however I still can't figure out how to list that information under each name I have listed
I've began playing around with VBA code that I'm finding online, but I can't get any of it to work. As of right now I'm just trying to figure out how to submit the data through a button click and have it appear on the second tab. Keep in mind, I'm still needing to figure out how to make the course populate for every employee.
This is the code I've been playing with today:
Sub TransferData() Dim sht1 As Worksheet Dim sht2 As Worksheet
Set sht1 = ThisWorkbook.Sheets("ss2") Set sht2 = ThisWorkbook.Sheets("ss1") sht2.Range("D6:D200") = sht1.Range("E13:E200") End Sub