1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to combine two sheets into one

Hey y'all. I'm sure this has a very easy answer but I'm going crazy trying to figure this out. I have two datasets with all the same columns, and I am simply trying to add one dataset underneath the other on the same sheet. But when I try to just copy and paste I'm getting all sorts of errors. Like saying that the the selected area needs to be the same size as the copy area, or when I try to insert one dataset above the other it overwrites the original. Has anyone had this issue before? Thank you!

submitted by /u/moose_on_a_hus
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#large dataset processing
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#google sheets
#combine
#sheets
#datasets
#columns
#copy
#paste
#insert
#overwrite
#errors
#size
#original
#area
#selected