Hi All!
Helps please...
I am creating a custom timesheet in Excel but upon submission I'm trying to paste the Employee name into the 'submissions' tab only as many times as there are filled out lines in the timesheet. I have a feeling the solution is quite simple...
Here's my code snippet so far:

    
'find the number of entries and set value as number of times to paste the employee name
    Range("K10").Select
    Selection.End(xlDown).Select
    ActiveCell.Offset(0, -5).Select
    
    'how do I set the number in this cell (in this case, line 4) as the number of times to paste the value?
    
'Copy the Employee Name
    Range("EEName").Select
    Selection.Copy
    Sheets("Submissions").Select
    
'Find the first blank cell in column A
    Set FirstBlankCell = Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
    FirstBlankCell.Activate

'Paste the data in as many times as there are entries
    
    With Range(FirstBlankCell, "A" & lastrow&).Select
    Selection.PasteSpecial xlValues '***as many times as found in ActiveCell.Offset(0,-5).Select above
    
    End With
Any pointing me in the right direction is greatly appreciated! :confused: