Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.
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.