I hope someone knows if this is possible. I went through all the steps to create a workbook, share it, copy it to the same file, and rename the copies. But when I tested it, I found out that the cells would not add to the main workbook, they would only enter one value.

In other words, I'm trying to let several people have their own copy of my workbook and access it from one network on our system. At the end of the week, I want to copy all of their numbers into one workbook so I can have one set of numbers for the week for a report to the boss. It is a very simple grid, dates on the left and categories on the top. However, if two users put a "1" in on the same date under the same category, when I merge the workbook it will only use one of the "1"'s-----I thought it would add them to show a "2" under that date and category.

Does anyone know if it is even possible to get these shared workbooks to merge and add all of the data in each individual cell??

Thanks,

Tim