Home

Inserting Copied Data Into a Table

%3CLINGO-SUB%20id%3D%22lingo-sub-574742%22%20slang%3D%22en-US%22%3EInserting%20Copied%20Data%20Into%20a%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-574742%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20create%20a%20macro%20for%20colleagues%20and%20I'd%20like%20to%20insert%20copied%20data%20from%20one%20worksheet%20into%20a%20table%20in%20another%20worksheet.%26nbsp%3B%20I'm%20trying%20to%20insert%20in%20the%20first%20row%20and%20have%20all%20other%20rows%20shift%20down%2C%20but%20I%20can%20only%20insert%20blank%20rows%3B%20I%20cannot%20insert%20the%20copied%20data.%26nbsp%3B%20I%20also%20considered%20pasting%20the%20copied%20data%20at%20the%20bottom%20of%20the%20table%2C%20but%20as%20the%20table%20will%20consistently%20be%20updated%20and%20expand%2C%20the%20bottom%20row%20will%20not%20always%20be%20the%20same.%26nbsp%3B%20Is%20there%20any%20way%20to%20insert%20copied%20data%20into%20the%20beginning%20of%20a%20table%20or%20is%20there%20a%20way%20a%20the%20macro%20could%20paste%20at%20the%20first%20blank%20row%20in%20the%20table%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-574742%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-612635%22%20slang%3D%22en-US%22%3ERe%3A%20Inserting%20Copied%20Data%20Into%20a%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-612635%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F343133%22%20target%3D%22_blank%22%3E%40Robyn_Keenan-01%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20would%20you%20go%20the%20difficult%20way%20and%20insert%20rows%20at%20the%20beginning%20of%20a%20table%20instead%20of%20just%20appending%20them%20at%20the%20bottom%20of%20table%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Robyn_Keenan-01
Occasional Visitor

I'm trying to create a macro for colleagues and I'd like to insert copied data from one worksheet into a table in another worksheet.  I'm trying to insert in the first row and have all other rows shift down, but I can only insert blank rows; I cannot insert the copied data.  I also considered pasting the copied data at the bottom of the table, but as the table will consistently be updated and expand, the bottom row will not always be the same.  Is there any way to insert copied data into the beginning of a table or is there a way a the macro could paste at the first blank row in the table?

1 Reply

@Robyn_Keenan-01 

Why would you go the difficult way and insert rows at the beginning of a table instead of just appending them at the bottom of table?

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies