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.