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
paulcc Posts 2 Registration date Thursday June 27, 2013 Status Member Last seen June 27, 2013 - Jun 27, 2013 at 01:48 PM
Related:
- Copy row paste at the top of each page
- Saints row 2 cheats - Guide
- How to copy paste youtube link on android - Guide
- Copy paste e with accent - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- Copy range data in a column to new column. ✓ - Excel Forum
2 responses
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!
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!
paulcc
Posts
2
Registration date
Thursday June 27, 2013
Status
Member
Last seen
June 27, 2013
Jun 27, 2013 at 01:48 PM
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.
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.
