Copy row paste at the top of each page

Closed
paulcc Posts 2 Registration date Thursday June 27, 2013 Status Member Last seen June 27, 2013 - Jun 27, 2013 at 11:42 AM
paulcc Posts 2 Registration date Thursday June 27, 2013 Status Member Last seen June 27, 2013 - Jun 27, 2013 at 01:48 PM
I need to copy a row, then paste it on the top row of multiple pages.

2 replies

Blocked Profile
Jun 27, 2013 at 11:48 AM
well good morning.

I hope that this isnt a school project...

sheets("sheet1").activate
activecell.entirerow.copy sheets("sheet2").cells(A,1) ''thsi copys entire row to sheet2

Now just plug in your variables and there ya have it...

Have fun!
0
paulcc Posts 2 Registration date Thursday June 27, 2013 Status Member Last seen June 27, 2013
Jun 27, 2013 at 01:48 PM
This isn't a school project. I am on staff at the University hospital.

Would you please give more details? I am not familiar with excel at that level.

I have a multi-page spreadsheet, which I will turn into a report. I want a row of column headings to appear on the top row of each page. When I copy and insert/paste, it only does it once, then I have to repeat. Since there are 36 pages, I need to know how to automate it, vs manually copying/insert pasting on every page.
0