MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
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
17 Experts available now in Live!