Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!
Sub Autopopulate() Dim Rng As Long, Rng1 As Range Application.ScreenUpdating = False Rng = Sheets("Unique List").Range("B" & Rows.Count).End(xlUp).Row ' the range of entries With Sheets("Broker Level") .Range("B8:B" & Rng).FillDown ' the range where the formula is in the first cell End With Application.ScreenUpdating = True End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.