copying a range from another worksheet

  • Thread starter Thread starter Haddock
  • Start date Start date
H

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.
 
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.
 
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
 
Back
Top