question

HN-1504 avatar image
0 Votes"
HN-1504 asked

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.

office-vba-devoffice-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers