Replicating cells in another worksheet based on the content of another cell

Hello,

I need your help for the report/data I'm currently working on. I have a tab that contains the summary information, and I need to transfer it to another tab for the detailed data.

Here is the Main tab:

Origin City Destination City Volume # of shipments
Hong Kong Kaohsiung 1.2 4
Bangkok Manila 3 2

Here is how it should appear in the detailed tab:

Origin City Destination City Volume # of shipments
Hong Kong Kaohsiung 1.2 4
Hong Kong Kaohsiung 1.2 4
Hong Kong Kaohsiung 1.2 4
Hong Kong Kaohsiung 1.2 4
Bangkok Manila 3 2
Bangkok Manila 3 2

Would you know the formula or macro for this because I got like a thousand information to replicate depending on the # of shipments.

Hi there,

check out this worksheet / have a look at the code inside.

Originally Posted by RHCPgergo

Hi there,

check out this worksheet / have a look at the code inside.

Thank you so much for your help! You have solved my problem and made my work easier :-)