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
- E with accent copy paste - Guide
- How to paste photo in word - Guide
- How to delete row in word - Guide
- Excel create unique id for each row - Excel Forum
- Vba autofill to last row ✓ - 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.