Hi All,
I've this code and want to save the Template File as Range value from Master File.
Can anyone help me please
Sub Get_Data()
Windows("Master File.xlsm").Activate
Range("A13:N71").Select
Selection.Copy
Windows("Template File.xlsx").Activate
Range("B4").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=True, Transpose:=False
End Sub
Based on the thread title the following tutorial, "Create Multiple Pivot Table Reports with Show Report Filter Pages", may be useful: https://www.excelcampus.com/pivot-ta....%20See%20More.
We may also be able to provide more help if we could see a sample of the source data and pivot table from which the monthly data is to be drawn.
Information on uploading Excel files is provided in the banner at the top of the page.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks