Combine Worksheets - Enterprise
By Roodyj on Wednesday, 31 January 2018
Posted in Kutools for Excel
Replies 3
Likes 0
Views 8.1K
Votes 0
It seems that the combine operation always combines starting after the last row, rather than into the same cells as the original. Attached screen as example. Is there a way that a combine operation can use a column approach so that each sheet uses the original cell addresses and overlays the two sheets?
Hello,
Can you please take a look at this feature https://www.extendoffice.com/product/kutools-for-excel/excel-summarize-data-from-multiple-worksheets.html?

It seems like we don't have such function yet.
qiuhongkun
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
This functional change would allow multiple people to develop separate portions of a master spreadsheet and then merge their work into one. This is what I am doing by developing different sections located in different cell areas, and then "overlaying" them into a Master layout that is already designed. Might be a good new tool addition.

Thank you for your attention.
Jim
Roodyj
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,
We would like to know the exact operation you want to process.
Can you please try to be more specific about your operation step by step?
Please try to demonstrate your operation with images.
qiuhongkun
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post