Need macros that creates new rows and copies matching info from sheet 1 to Sheet 2

Hi

If you look at the attached file, I want to automatically create new rows on sheet "sorted by Broker" based on information that I continuously receive from clients which i copy and paste the list into sheet 1 Column A. Client gives a list of brokers to me and I want that client's information inserted in a new row for the corresponding broker on sheet "sorted by broker". the client information i want duplicated is B1:B3 in sheet 1 into the PM, Firm, Date columns in sheet 2. This is an ongoing process so I want to be able to keep adding rows of matching data to sheet 2 whenever i copy data into sheet 1 column A and hit "Add Data"

In the attached file, I have copied and pasted cells to show how I want the sheet to work for you to get a better idea.

I would really appreciate the help! I am getting very confused on how to approach it

Thanks!

hello!

Thank you

In the attached file, Ive include sample data. Brokers listed on sheet 1 are represented by alphabets, A C D G, and hte information i want copied over is B1:B3. In the second sheet, Brokers are again listed in column A from A to L. And then I have new rows created under A C D G where the information from sheet 1 B1:B3 is copied over.

I can try and recreate it with actual names to make it easier

here is an easier sample to understand

Originally Posted by PCI

Do you want to clear data in sheet "Add Data" when copy paste is done ??

I dont really mind about that as Ive already created a clear data macro. Im only really concerned about creating the new rows for the brokers based on the list ive writter in sheet 1 column A and then copying over sheet 1 B1:b3 to the new rows created

Hmm almost but not quite, it copies the information for the first one correctly but then continues to paste the next three rows underneath it instead of under their respective brokers

Originally Posted by vpan

Hmm almost but not quite, it copies the information for the first one correctly but then continues to paste the next three rows underneath it instead of under their respective brokers

My mistake, it copies the the whole four rows correctly with the right broker. Only thing is I have a static list of brokers where I will continue to add contacts for. so instead of copying over the broker information too, I need a new row created under the brokers already listed in sheet 2 Column A. in those new rows under the right broker is where I want the B1:b3 pasted.

My apologies for the confusion

That's perfect! Thank you so much, I really appreciate it!