Merge several identical sheets into one (Excel 2000)

Topic

New Reply

I have created a worksheet with 20 rows of employee names. This has been sent out and each employee was to fill in their appropriate row and return it. I have copied each of these returned worksheets into one file and would now like to compile all the information into a master sheet. Could anyone please tell me how to do this?

Thanks..Susan

Reply | Quote

Replies

If you had many more employees, or if you have to do this often, it would become worth while to think about a solution involving formulas or VBA code. With “only” 20 employees, it’s probably fastest to copy each filled in row and paste it into the master sheet.

Reply | Quote

If you had many more employees, or if you have to do this often, it would become worth while to think about a solution involving formulas or VBA code. With “only” 20 employees, it’s probably fastest to copy each filled in row and paste it into the master sheet.

Reply | Quote

Would Data Consolidation work for you? Look under the Data menu.

Reply | Quote

Would Data Consolidation work for you? Look under the Data menu.

Reply | Quote

Thanks for your responses. I am not sure how data consolidation works. However, I did find a solution that worked. I used concat(sheet1A1+sheet2A1+sheet3A1)etc. and dragged for formula through the entire summary sheet.

..Susan

Reply | Quote

Thanks for your responses. I am not sure how data consolidation works. However, I did find a solution that worked. I used concat(sheet1A1+sheet2A1+sheet3A1)etc. and dragged for formula through the entire summary sheet.

..Susan

Reply | Quote