copying a range from another worksheet

[Haddock]

i receive a worksheet from my broker and i want to use that data in another
worksheet. I want do to some daily calculations on that data and become
tired of copying it by hand. I searched for a way to copy a certain range,
but nothing found yet. I wonder if someone could help me.

 

[Norman Harker]

Hi Haddock!

Open both workbooks
In your workbook type =
Navigate to the broker's workbook
Select the range to be copied
Press Enter


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Ron de Bruin]

Hi Haddock

With the file from the Broker open (Broker.xls) you can run this macro to copy a range from that workbook
in the workbook where you copy this macro.

Sub test1()
Dim srceRng As Range
Dim destRng As Range
Set srceRng = Workbooks("Broker.xls").Sheets("sheet1").Range("a1:d50")
Set destRng = ThisWorkbook.Sheets("sheet1").Range("A1")
srceRng.copy destRng
End Sub