combining files into one master excel file

Copper Contributor

I need some help,

 

I have several excel file with similar/ duplicated data.   All the files have the same same/similar layout.   I would like to create one workbook from several different workbooks files.  I would like to delete the duplicate data information files and have one that is can be co authored/ have different users enter data as well.  

What is the most efficient way to do this?

I am using Office 365 Business Premium.    

1 Reply
You've posted in the Community Discussion space, meant for questions directly about the Tech Community. I've moved your question to the Excel space for better visibility.