Nov 27 2018 12:08 PM - edited Nov 27 2018 12:22 PM
Eg. I have ten worksheets, all have same columns: email address, first name, last name. Each worksheet has 100 rows filled. I want to combine them into one worksheet that will have all the entries, i.e. 1000 lines of data. How do I do this? (I have simplified this question. I actually have more columns and data, but the question is clearer this way.) Thanks.
Nov 27 2018 12:42 PM
SolutionIn general it's here https://professor-excel.com/merge-excel-files-combine-workbooks-one-file/. What to use depend on are you on Excel Online only or not and is that static data (i.e. one time operation) or your files are updated from time to time.
Nov 27 2018 01:16 PM
Thank you. I tried some of the choices and ended up doing the Professor Excel trial. That was easy. I guess I will have to purchase it if I need to do it again. I couldn't really figure out the other methods.
Nov 27 2018 12:42 PM
SolutionIn general it's here https://professor-excel.com/merge-excel-files-combine-workbooks-one-file/. What to use depend on are you on Excel Online only or not and is that static data (i.e. one time operation) or your files are updated from time to time.