VBA + Excel - Copy & Paste From Pivot table

HN 1 Reputation point


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.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,668 questions
0 comments No comments
{count} votes