VBA to copy data from master workbook to another

vinidis

New Member
Joined
Aug 11, 2017
Messages
7
Hi everyone!

I have a problem with the following task:
I have a master workbook where I record my data in 9 columns (B4:B54 to I4:I54) each has a header. I'd like to copy the values from this sheet to another workbook (Data).
I've tried the Range method, but it works only with one cell.

Can anyone help me with this?

Thanks in advance.
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

JefferyLi

New Member
Joined
Jul 16, 2019
Messages
9
Workbooks("Source WB name").Worksheets("Source WS name ").Columns("B:I").Copy
Workbooks("Destination WB name").Worksheets("Destination WS name").Range("A1").PasteSpecial Paste:=xlPasteValues
 

Watch MrExcel Video

Forum statistics

Threads
1,102,302
Messages
5,486,048
Members
407,529
Latest member
netojose

This Week's Hot Topics

Top