Coping data from workbook to another workbook

[besis]

Hi,

I need a VBA code that copies data from workbook1 from a specific sheet (sheet name = DATA1) to workbook2 to a specific sheet (sheet name = DATA2)

I need to copy just values

The range that need to be copied is:
B5:S16
B18:S29
B31:D42
X3:Z47
AC3:AE21
AC23:AD34
AC36:AD47

Thanks in advance:
B.

[kev_]

Are values pasted to same cells in Data2 as in Data1t?
In which workbook is the VBA?

[besis]

Hi,

Yes, values has to be pasted to same cells in Data2 as in Data1.
I would like VBA code to be in workbook2.

Thanks:
B.

[kev_]

This code opens workbook1, copies the values , and closes workbook1

Put in general module in workbook2 and amend the 3 constant values to match your file name and sheet names

Please Login or Register  to view this content.

To paste values only
replace:

Please Login or Register  to view this content.

with either:

Please Login or Register  to view this content.

or this single line which attributes values directly to the cells - this is the fastest method

Please Login or Register  to view this content.

[besis]

Hi,

Thank you for this solution. This helps a lot.

All the best.
B.