• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Insert rows and repeat data

P

Pinang

Member
Hi,

I want macro to inset 5 rows and repeat data, attached example file with input and output data.

Any code or formula suggestion please.
 

Attachments

  • Insert Rows and repeat data .xlsb
    8.7 KB · Views: 4
Hi Pinang
Using some trick in Power Query, for you case you are repeating fix row and fix data, the attached column give you flexibility to insert different number of row, just change the no.row column accordingly and goto second worksheet and refresh it
 

Attachments

  • Insert Rows and repeat data_Chris.xlsx
    19.6 KB · Views: 5
You must log in or register to reply here.
Back
Top