+ Reply to Thread
Results 1 to 2 of 2

VBA to copy pivot dates and paste into sheet and apply formula

  1. #1
    Registered User
    Join Date
    08-13-2016
    Location
    Chennai,Tamilnadu
    MS-Off Ver
    office 2007,2010
    Posts
    4

    VBA to copy pivot dates and paste into sheet and apply formula

    Dear experts

    I have two master data in two different sheet i want apply vba to copy header of dates from pivot and paste into data range header values

    In the sheet PivotCap_Rev two pivot which contains dates in both In the first pivot i want copy dates from B5 till date end and paste into C20 in sheet WizardReport and second pivot i want copy B20 till date end and paste into C29 in sheet WizardReport
    In the third data range i want copy same as first pivot dates and paste into C37 in sheet WizardReport

    I have worksheetfunction VBA in WizardReport sheet which is not allow to copy and paste the dates from one sheet to another

    Find the attachment sheet WizardReport in red color which is my requirement.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-13-2016
    Location
    Chennai,Tamilnadu
    MS-Off Ver
    office 2007,2010
    Posts
    4

    Re: VBA to copy pivot dates and paste into sheet and apply formula

    Any experts could help me?

+ 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. VBA to copy pivot and paste into target sheet of referred cell
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2016, 11:37 PM
  2. need vba code to copy pivot table and paste into Master sheet end row
    By johnlara in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2016, 03:59 PM
  3. Create A Pivot Off a Already made pivot and Copy Paste in Separate Sheet
    By takeawalkk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2015, 01:34 PM
  4. VBA code to put a pivot and copy paste the data on a other sheet
    By aravindkm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-28-2013, 12:07 PM
  5. Loop through dates and copy/paste Saturdays and Sundays to another work sheet
    By Jeep56 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-18-2013, 05:00 PM
  6. How to copy data with formula and paste another sheet as paste spl -value only
    By sumesh56 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-14-2013, 09:03 PM
  7. Replies: 7
    Last Post: 03-27-2011, 09:03 AM

Tags for this Thread

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