Duplicate row base on value given

[cjGod]

Hi there,


Need help to build a vb script macro to duplicate the entire row base on the value given in Column A, the duplicates will be in sheet 2 always starting from A1. For example duplicate the row of B2 and C2 5 times, which is based on the value in A2. I may need to add in more columns in the future in D, E and so on.

Attached is the example in the file attached
Please do help

Thanks

[snb]

Visiting a restuarant wouldn't be fine for my appetite...

[cjGod]

Anyone can help on that request?

[watersev]

hi, cjGod, please check attachment, run code "test" or press Run

[cjGod]

Hi watersev,

Many thanks for the help in creating the macros. It works well!
But is there a way that I can edit the macros so that in the event I need to add in values in Column D and so on, it can duplicate accordingly also.

[cjGod]

Hi There,

Anyone can help me with this?

[watersev]

yes, you can. Only you know what is added and what it should be as a result

[cjGod]

Hi watersev,

I have attached the previous excel file that you have sent with my changes needed.
Is there a way to build a dynamic macros that I can change myself, in the event I need to add in new columns.


Thanks

[watersev]

hi, cjGod, please check attachment, run code "test". Try to add columns and run the code. The output is on a newly created sheet.