Most valuable professional
  • Hot Topics

Excel Copy/paste macro

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:

  • Excel
  • Microsoft Excel