Hi all Bit stumped & seeking assistance, vba isnt my thing. I have a work book with several sheets in it. I am trying to copy the data from M2 on each sheet & paste it into Column C but in the next blank cell. At the end of running the macro i would like to refresh a pivot table = PivotTable1 Help would be appreciated So far i have Code: Sub RefreshGraphs() ' ' RefreshGraphs Macro ' ' Sheets("PIVOT").Select Range("D10").Select ActiveSheet.PivotTables("PivotTable3").PivotCache.Refresh Sheets("MTD Trending").Select End Sub & Code: Worksheets("TRUCKS").Range("M2").Copy _
This question generated 14 answers. To proceed to the answers, click here.
This thread is current as of July 18, 2017.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel