how do i combine excel worksheets

K

kgemind

Working with Excel 2007, we start with a status report of pre-populated
columns and rows of data. Multiple agents independently update the rows that
are assigned to them, while leaving the unassigned rows blank. When all
agents complete the assignment, we must combine their work into the master
worksheet, then delete duplicate rows. What excel function would combine
these multiple worksheets? Any way to easily delete the duplicates?
 
J

JR Hester

Do multiple agents actually add rows of new data or simply have to add
additional rows of original to add their quantites? If not adding truly NEW
row, have you considered using the 3D formula approach. Multiple identiacal
worksheets fro each agents, with a summary sheet to add all agents togenther.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top