Need macro that can transfer data to the next row of the master sheet

[tantcu]

Hello,

I'm working on the project that forecast sales for multiple customers. I have one template that uses to forecast for each customer. Therefore, I want to be able to transfer my data to the master sheet when I'm done with one customer and move on to the next one. Please let me know if you can help me on this. I also attached a sample spreadsheet and have one tab that expected the result should be.
Test Macro.xlsx

Thanks,

[stnkynts]

Try this and see how close it is:

Please Login or Register  to view this content.

[tantcu]

Thank you so much. It worked great!