Obviously my code above is wrong, but it should give you an idea of what I'm looking to accomplish. Thanks for any help! Also I attached a sample spreadsheet.
Private Sub AutoFill() Dim LastRowInA As Long Dim r As Range Set r = Range("Match of left(Main!B2") LastRowInA = Range("A1048576").End(xlUp).Row r.AutoFill Destination:=Range("Match of left(Main!B2" & LastRowInA) End Sub
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!