Forum Discussion
Consolidating data from multiple worksheets
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.
In 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.
2 Replies
In 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.
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.
