Excel Macro insert values from List into cells


I’m working on a report that requires a certain macro to produce it. I have a list of 185 brokers in a tab called Regular Brokerlist. I also have a summary sheet called All. Each section on the table all has 251 rows. I need a macro that pastes the first broker in the brokerlist into Cell C4 of the All worksheet and then will paste the next broker in the brokerlist to cell 255 and so on, until the brokerlist is empty.

I’m a beginner at using VBA.


Thank you very much for the help.


By: Ricky

Leave a Reply

Your email address will not be published. Required fields are marked *