Oct 18 2019 08:46 AM
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.
Oct 19 2019 04:47 AM - edited Oct 19 2019 04:51 AM
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
Oct 21 2019 09:22 AM
@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?
Oct 22 2019 09:11 AM
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.