VBA/Copy Paste

Ezzath - Mar 26, 2017 at 03:19 PM

I have a dataset with 300 rows and 10 columns. the first 4 columns have the metadata and then 6 columns with different values.
what I want to do is:
i) insert 5 rows underneath the first row, ii) copy the values in the metadata columns 5 times, iii) cut the values in the remaining columns and paste it in a row (sequentially).
the end product to have 6 rows that contains; the same metadata and the 6 different values from the remaining columns.

Would anybody helps me.