VBA + Excel - Copy & Paste From Pivot table

HN 1 Reputation point
2021-08-31T19:40:25.2+00:00

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.

Microsoft 365 and Office Excel For business Windows
Developer technologies Visual Basic for Applications
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.