VBA + Excel - Copy & Paste From Pivot table
Greetings,
I am attempting to write a VBA code in excel and cannot get it correct because I am a rookie.
What/how should I write if I want to copy the value of a cell, b5, from a pivot table in one workbook and paste the value to a cell, A3, in a different workbook?
I was going to start with something like:
Sub Copy_Move()
Workbooks("New Book.xlsx").Worksheets("Processing Pivot").cells(5,2).copy_
Workbooks("Data Book.xlsx").Worksheets("Sheet 1").Cells(3,1)
End Sub
My coordinates/positions are always static for my copying of the pivot table, so I can use hardcoded numbers but I struggle with arranging the syntax. Oh boy, my head is spinning.