Copy row paste at the top of each page
Closed
paulcc
Posts
2
Registration date
Thursday 27 June 2013
Status
Member
Last seen
27 June 2013
-
27 Jun 2013 à 11:42
paulcc Posts 2 Registration date Thursday 27 June 2013 Status Member Last seen 27 June 2013 - 27 Jun 2013 à 13:48
paulcc Posts 2 Registration date Thursday 27 June 2013 Status Member Last seen 27 June 2013 - 27 Jun 2013 à 13:48
Related:
- Copy row paste at the top of each page
- Saints row 2 cheats - Guide
- How to copy paste youtube link on android - Guide
- How to delete a row in word - Guide
- Pi copy paste - Guide
- E with accent copy paste - Guide
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 27 June 2013
Status
Member
Last seen
27 June 2013
27 Jun 2013 à 13:48
27 Jun 2013 à 13:48
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.
