Hi guys, I'm racking my brain here. I'm trying to find a vba code that will allow index and match for multiple occurrences, then having that data filled into a column so I can pull that data into a userform. Basically each time an employee's name (will always be cell L1) comes up in col B, I need the date from same row, col E. Then have that date pasted into col M, starting with cell M1 and continuing down the rows for all occurrences, stopping after they all have been populated so I don't have 50 cells with formulas and only 3 occurrences of the employee's name. To make matters worse, I will also need the row number from each occurrences to be pasted into col N.
From there, I have the vba to load it into my userform for the next fun part of my project.
THANK YOU!!!
Bookmarks