Home

Importing multiple cells from one sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-918803%22%20slang%3D%22en-US%22%3EImporting%20multiple%20cells%20from%20one%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-918803%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20import%20mulitiple%20cells%20from%20one%20sheet%20onto%20another.%26nbsp%3B%20I%20use%20this%20formula%3A%26nbsp%3B%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EIMPORTRANGE%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%22LINK%20TO%20SHEET%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%22Sheet1!A2%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EI%20need%20to%20repeat%20this%20process%20for%20every%20cell%20below%20A2...so%20A3%2C%20A4%2C%20etc.%26nbsp%3B%20Is%20there%20a%20way%20to%20quickly%20do%20that%3F%26nbsp%3B%20Right%20now%20if%20I%20copy%20and%20past%20the%20formula%2C%20it%20just%20keeps%20pasting%20cell%20A2%20into%20the%20next%20one.%26nbsp%3B%20%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-918803%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-919608%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20multiple%20cells%20from%20one%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-919608%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428932%22%20target%3D%22_blank%22%3E%40amandaleonardo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3ECan%20you%20try%26nbsp%3BRange.Copy%20method%20in%20Excel%3F%3C%2FP%3E%3CP%3EYou%20need%20to%20provide%20range%20%26nbsp%3Bfrom%20Sheet1%20to%20be%20copied%20to%20Sheet2%3C%2FP%3E%3CP%3EYou%20can%20try%20following%20macro.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESub%20CopyRanage1()%3CBR%20%2F%3EWorksheets(%22Sheet1%22).Range(%22a2%3Aa20%22).Copy%20Destination%3A%3DWorksheets(%22Sheet2%22).Range(%22a2%22)%3CBR%20%2F%3EEnd%20Sub%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-922615%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20multiple%20cells%20from%20one%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-922615%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F17911%22%20target%3D%22_blank%22%3E%40SUPARNA%20KANSAKAR%3C%2FA%3E%26nbsp%3B%20%26nbsp%3BThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20I%20have%20never%20used%20Macros%20before...only%20the%20formulas.%26nbsp%3B%20Do%20you%20have%20any%20links%20to%20info%20on%20where%20I%20input%20this%20and%20how%20to%20do%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-927284%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20multiple%20cells%20from%20one%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-927284%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428932%22%20target%3D%22_blank%22%3E%40amandaleonardo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20enable%20the%20developer%20option%20in%20Excel.%20Please%20check%20this%20link.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fshow-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fshow-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20view%20the%20attachment.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
amandaleonardo
New 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.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies