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.
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?
Please enable the developer option in Excel. Please check this link.
Please view the attachment.