Importing multiple cells from one sheet

Copper Contributor

I need to import mulitiple cells from one sheet onto another.  I use this formula: =IMPORTRANGE("LINK TO SHEET","Sheet1!A2")

 

I need to repeat this process for every cell below A2...so A3, A4, etc.  Is there a way to quickly do that?  Right now if I copy and past the formula, it just keeps pasting cell A2 into the next one. 

3 Replies

@amandaleonardo 

Hello,

Can you try Range.Copy method in Excel?

You need to provide range  from Sheet1 to be copied to Sheet2

You can try following macro.

 

Sub CopyRanage1()
Worksheets("Sheet1").Range("a2:a20").Copy Destination:=Worksheets("Sheet2").Range("a2")
End Sub

 

@SUPARNA KANSAKAR   Thank you.

 

Unfortunately, I have never used Macros before...only the formulas.  Do you have any links to info on where I input this and how to do it?

@amandaleonardo 

 

Hello,

 

Please enable the developer option in Excel. Please check this link.

https://support.office.com/en-us/article/show-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45

 

Please view the attachment.