+ Reply to Thread
Results 1 to 2 of 2

Is that possible to copy and paste pivot table to multiple sheets?

  1. #1
    Registered User
    Join Date
    12-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    1

    Is that possible to copy and paste pivot table to multiple sheets?

    for my school project, I am right now doing time tracking for all of my activities throughout the day with excel. Here is basically what I am doing: For everything I do, I record and put in start time and end time for the activity.(I use simple formula to subtract these twos) If my day goes on like study, break, study, meal, study, break and each activity takes one hour for each, I have total of 3 hours studying, 2 hours taking break and one hour for meal. I am using pivot table to show all totals for each activity. Pivot table is working best as far as my knowledge goes as I can choose and look up total of multiple activity combined. The problem here is I am making one sheet per a day and I need to continue this for three months. (So that seems like 90 worksheet). What I was thinking is I make Sheet 1 as master sheet. Then, copy and paste the entire sheet for 90 sheets assuming all formulas including pivot table go along with them. then, when I put in new data to other sheet,magic happens and values in pivot tables will change relatively after refresh. You might be probably laughing hard at me right now. I know..I tried it for like 3 sheets. Simple formula to subtract endtime and start time still work accordingly with new data. But, Pivotal table is playing dead at all. I researched and found that that might be problem with reference and absolute cell reference thingy. Could you please help me how to fix the problem ( to make pivotal table work for different worksheet). All the cells used ( including column and row ) will be entirely the same for all worksheets. The only difference aka problem is different sheet. Thank you so much in advance! I spent the whole day figuring out.
    I want to make my question clear.
    I want to use sheet 1 as a template and copy it down to next 90 sheets taking all contents except data. Is there anyway I can copy and paste the whole template to another 90 sheets while making pivot table work and calculate and update itself according to relative data from each own worksheet? I use excel 207 btw. Below is picture of what is happening.
    table 2.jpg
    If you have other suggestion with least time possible, I'd love to hear that!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,124

    Re: Is that possible to copy and paste pivot table to multiple sheets?

    To attach a Workbook
    (please do not post pictures of worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to Copy Pivot Table and Paste a Regular Data Table in the Same Position
    By webfeet2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2013, 06:34 AM
  2. Copy paste multiple sheets including pivot table formats
    By Fursmanm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2012, 09:14 AM
  3. Replies: 5
    Last Post: 07-01-2011, 01:36 AM
  4. Copy / Paste Pivot Table to PPT
    By skizz135 in forum Excel General
    Replies: 1
    Last Post: 07-08-2008, 02:36 PM
  5. Pivot table copy and paste
    By yllee70 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-23-2005, 04:06 AM

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