Results 1 to 2 of 2

Thread: [RESOLVED] Excel Vba I’m need help with a copy sheet code!

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Sep 2011
    Posts
    24

    Resolved [RESOLVED] Excel Vba I’m need help with a copy sheet code!

    I have a workbook with many sheets one of the sheets is a Pivot Table. I would like to give the user the option to create a new sheet with the pivot table sheet and the sheet that contains its source data only.

    This would allow them to continue to work without the large workbook needing to be open. This code will be run from the pivot table sheet.

    I would appreciate any assistance with this code.

    Thank you.

  2. #2
    Hyperactive Member
    Join Date
    Oct 2010
    Location
    Indiana
    Posts
    457

    Re: Excel Vba I’m need help with a copy sheet code!

    So are you wanting them to be able to update the data on the original?? If thats the case you should just create 2 separate workbooks. One with the data, and the other with the pivot table. You can link the pivot table to the data from the other workbook.

Tags for this Thread

Posting Permissions

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



Click Here to Expand Forum to Full Width