What I would like to do is take the data from one file's pivot table and put it into another document (without pivot table). The data that is being copied is generated depending on what time of day/interval the data occurs in.
My problem is that the data from weekdays occurs from 7:00 to 21:00 and the data from the weekends is 7:30 to 17:00. If I do a straight copy/paste it will not end up in the right rows.
I've attached a WEEKDAY, WEEKEND and then the document that it needs to be pasted into.
Last edited by Wheelie686; 04-14-2013 at 05:28 PM.
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks