+ Reply to Thread
Results 1 to 19 of 19

Copying moving formulas from page 1 to next page on worksheet

  1. #1
    Registered User
    Join Date
    02-01-2013
    Location
    FL,USA
    MS-Off Ver
    Excel 2010
    Posts
    27

    Copying moving formulas from page 1 to next page on worksheet

    Thanks for the help with the formulas in previous thread.
    Now I started using formulas in the first page and found there is not enough cells, so I need to go to the next page in the worksheet and copy all the formulas.
    I have already put text and numbers in the 1st page.
    I get the copy function to work ,but when I go to paste nothing there.
    Do I have to remove all other data then copy or do I just need to make a new worksheet with endless cells?
    Not sure where to go here, so I'm again asking for your help.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Copying moving formulas from page 1 to next page on worksheet

    Please Login or Register  to view this content.
    What kind of data you have, that you don't have enough rows.

    How many rows do you have?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Copying moving formulas from page 1 to next page on worksheet

    ummm not enough cells?????? you have 17 179 869 184 (=1048576 rows x 16384 columns)...thats 17 BILLION cells on 1 sheet, and you used them all up?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    02-01-2013
    Location
    FL,USA
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Copying moving formulas from page 1 to next page on worksheet

    I typed wrong info
    Page #1 has 11 Columns & 17 Rows. That is where I built my spread sheet. Now I need to do the same thing on page #2..
    See Pic Insert might explain
    Attached Images Attached Images
    Last edited by jterr; 02-08-2013 at 05:27 PM.

  5. #5
    Registered User
    Join Date
    02-01-2013
    Location
    FL,USA
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Copying moving formulas from page 1 to next page on worksheet

    Quote Originally Posted by FDibbins View Post
    ummm not enough cells?????? you have 17 179 869 184 (=1048576 rows x 16384 columns)...thats 17 BILLION cells on 1 sheet, and you used them all up?
    Nope see lastpost. I'm really having connection issues here, hangs then closes then I start over and it already posted, hope this doesn't double post or something

    Sorry for my computer problems....
    Last edited by jterr; 02-08-2013 at 06:43 PM.

  6. #6
    Registered User
    Join Date
    02-01-2013
    Location
    FL,USA
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Copying moving formulas from page 1 to next page on worksheet

    Anyone offer any help

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Copying moving formulas from page 1 to next page on worksheet

    Yes, I am having connection problems as well, we understand that sometimes the server hiccups and you end up with a double post.

    Also, I think it would be far more helpful if you uploaded the sample workbook, rather than a picture of it - we cannot edit the picture

  8. #8
    Registered User
    Join Date
    02-01-2013
    Location
    FL,USA
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Copying moving formulas from page 1 to next page on worksheet

    Here is the file you requested
    Attached Files Attached Files

  9. #9
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Copying moving formulas from page 1 to next page on worksheet

    And now it's interesting to know what you want to achieve.

    Please also add the desired (expected) result in your sheet.

  10. #10
    Registered User
    Join Date
    02-01-2013
    Location
    FL,USA
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Copying moving formulas from page 1 to next page on worksheet

    Quote Originally Posted by oeldere View Post
    And now it's interesting to know what you want to achieve.

    Please also add the desired (expected) result in your sheet.

    The end result would be to have each page have sub totals and the worksheet would have the total if possible.
    Thanks

  11. #11
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Copying moving formulas from page 1 to next page on worksheet

    I don't see an new excel file added, with the expected result!!!

  12. #12
    Registered User
    Join Date
    02-01-2013
    Location
    FL,USA
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Copying moving formulas from page 1 to next page on worksheet

    Sorry,
    I can't get it to copy the formulas ,so I don't know how to get the subtotals on the pages.

  13. #13
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Copying moving formulas from page 1 to next page on worksheet

    See the attached file, with an copy of your sheet (on sheet 2).
    Attached Files Attached Files

  14. #14
    Registered User
    Join Date
    02-01-2013
    Location
    FL,USA
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Copying moving formulas from page 1 to next page on worksheet

    Quote Originally Posted by oeldere View Post
    See the attached file, with an copy of your sheet (on sheet 2).
    I don't understand. I thought rows 18-34 would be page 2, 35-51 page 3....
    How do I copy formulas or just rewrite them for each page???

  15. #15
    Registered User
    Join Date
    02-09-2013
    Location
    Here
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Copying moving formulas from page 1 to next page on worksheet

    Here is a simple one. It could be spiced up to allow you to specify the number of the sheet you are creating via a dialog box.


    Sub Copysheet()
    Sheets.Add.Name = "Sheet2"
    Range("a1").Select
    Sheets("Sheet1").Range("A1:k17").Copy Destination:=ActiveCell
    ActiveSheet.Range("a2:h16").ClearContents
    ActiveSheet.Range("j2:k16").ClearContents
    ActiveSheet.Range("a2").Select
    End Sub

  16. #16
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Copying moving formulas from page 1 to next page on worksheet

    I bet you want something else, but since you don't give us any clue what you want to achieve, I can't help you more than I already did.

  17. #17
    Registered User
    Join Date
    02-01-2013
    Location
    FL,USA
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Copying moving formulas from page 1 to next page on worksheet

    Quote Originally Posted by JES1 View Post
    Here is a simple one. It could be spiced up to allow you to specify the number of the sheet you are creating via a dialog box.


    Sub Copysheet()
    Sheets.Add.Name = "Sheet2"
    Range("a1").Select
    Sheets("Sheet1").Range("A1:k17").Copy Destination:=ActiveCell
    ActiveSheet.Range("a2:h16").ClearContents
    ActiveSheet.Range("j2:k16").ClearContents
    ActiveSheet.Range("a2").Select
    End Sub
    You have to remember I havn't done excel in over 10years, so You just completely lost me.
    Where would I put that, and you say sheet 2, but when I'm looking at sheet 1 each of the rows1-17,18-34...are showing up as pages on sheet 1.

  18. #18
    Registered User
    Join Date
    02-09-2013
    Location
    Here
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Copying moving formulas from page 1 to next page on worksheet

    Sheet2 is added by the macro. Attached is your workbook with the macro embedded.

    Whether this does what you are looking for depends on your goal. If you want multiple tabs with one entry sheet on each tab, this macro creates the first of the duplicate tabs and populates your formulas. If you are looking to copy your formulas down the same tab then, then this doesn't work for you.
    Attached Files Attached Files
    Last edited by JES1; 02-09-2013 at 03:16 PM.

  19. #19
    Registered User
    Join Date
    02-01-2013
    Location
    FL,USA
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Copying moving formulas from page 1 to next page on worksheet

    Thanks I guess I will just go back to writing with pen and paper.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1