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
Highlighted
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
Highlighted

@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?