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

6 thoughts on “Excel Macro insert values from List into cells

  1. ig

    We’re a gaggle of volunteers and opening a brand new scheme in our
    community. Your web site offered us with useful information to work on. You have performed an impressive process and our whole group
    will probably be thankful to you.

  2. Glinda

    Excellent website. A lot of useful information here. I am sending it
    to several pals ans also sharing in delicious. And of course, thanks in your effort!

  3. WaynePaymn

    Unbelievably purchaser gratifying plot. Matchless details offered on handful clicks. [url=http://ko21.fr/te-deseo-buenas-noches/]te deseo buenas noches[/url]

  4. Ernest Brouillet

    There are certainly a lot of details like that to take into consideration. That is a great point to bring up. I offer the thoughts above as general inspiration but clearly there are questions like the one you bring up where the most important thing will be working in honest good faith. I don?t know if best practices have emerged around things like that, but I am sure that your job is clearly identified as a fair game. Both boys and girls feel the impact of just a moment?s pleasure, for the rest of their lives.

Comments are closed.