Home

Merging Two Excel Spreadsheets

%3CLINGO-SUB%20id%3D%22lingo-sub-437554%22%20slang%3D%22en-US%22%3EMerging%20Two%20Excel%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-437554%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20same%20data%20from%20two%20different%20schools%20that%20I%20need%20to%20merge%20into%20one%20spreadsheet.%20I%20have%20previously%20been%20able%20to%20cut%20and%20paste.%20Now%20I%20get%20the%20following%20message%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CEM%3ETo%20paste%20all%20cells%20from%20an%20excel%20worksheet%20into%20the%20current%20worksheet%20you%20must%20paste%20into%20the%20first%20cell%20A1%20or%20R1C1%3C%2FEM%3E.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20with%20this%20is%20that%20it%20replaces%20the%20information%20from%20the%20first%20spreadsheet%20instead%20of%20adding%20to%20it.%20I%20have%20been%20cutting%20and%20pasting%20all%20year%20with%20no%20problems.%20However%2C%20I%20stared%20getting%20this%20message%20this%20week.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-437554%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-438836%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%20Two%20Excel%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-438836%22%20slang%3D%22en-US%22%3EPerhaps%20you%20have%20copied%20more%20rows%20than%20can%20fit%20in%20the%20target%20sheet%3F%3C%2FLINGO-BODY%3E
Highlighted
KWrightFLEX
Occasional Visitor

I have the same data from two different schools that I need to merge into one spreadsheet. I have previously been able to cut and paste. Now I get the following message:

To paste all cells from an excel worksheet into the current worksheet you must paste into the first cell A1 or R1C1.

 

The problem with this is that it replaces the information from the first spreadsheet instead of adding to it. I have been cutting and pasting all year with no problems. However, I stared getting this message this week.

1 Reply
Perhaps you have copied more rows than can fit in the target sheet?
Related Conversations
Referencing/adding last item in multiple groups
cdolan27 in Excel on
0 Replies
Averaging hourly data in excel
EthanBala in Excel on
0 Replies
Conditional Formatting Help!
mgiglab in Excel on
0 Replies
listing items in ranked order
willowbe in Excel on
1 Replies
Remove duplicates not working properly
Mcelli in Excel on
1 Replies