Add column headers for each 25 rows

[Pavan.Sada.PS]

Hello Friends,

Need help in adding the column headers for each of 25 rows. Plz look at the attached spreadsheet the column header in the row number one has to be pasted after 25 rows.

I have a list of around 75000 line and adding it manually consuming more time. request you to please help in creating a macro for it.

[AB33]

I am Not sure if the attached is what you are after.

[Pavan.Sada.PS]

Hello AB33,

Let me explain in detail.. when i extract a file for the list of invoices what I would get as an output is like the file i have attached in this reply.. Which consists of row 1 (column Headers, rages from A1:___1) [column varies]
and the invoice details will start from row 2 till row number 15001

I would require the same column header to be repeated (copied and pasted) for 25 invoices each: I mean. an empty row should be added after a count of 25 invoices (25 rows)and in that added row the column header should get pasted. the action should repeat until the 15000 invoices are completed.

hope i have explained in detail.

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[Pavan.Sada.PS]

Yepieeeeeeee.. This really works. Thanks a bunch for helping me in this.. You rock!!!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.