Hi guys,
I'm trying to merge multiple Excel files from throughout my company into one master sheet. Each file has 3 sheets, and are identicle in terms of rows, columns, etc. My hope is to be able to send the Excel files out to each "process owner", have them enter data, which is then inputted into the master sheet. I also want the data to be added together, i.e. if one person puts a 3 for a category and a different person puts a 2, the master sheet would display a 5.
Thanks for any and all help.
-Doug
I'm trying to merge multiple Excel files from throughout my company into one master sheet. Each file has 3 sheets, and are identicle in terms of rows, columns, etc. My hope is to be able to send the Excel files out to each "process owner", have them enter data, which is then inputted into the master sheet. I also want the data to be added together, i.e. if one person puts a 3 for a category and a different person puts a 2, the master sheet would display a 5.
Thanks for any and all help.
-Doug