Merging a shared workbook

[tannert13]

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

[arthurbr]

Hello Tim and welcome to the board

Shared workbooks will not do what you want because they are basically the same workbook that everybody sees. So if A changes cell A1 it will change in all other workbooks, etc..
Make a copy of the sheet, with the necessary security precautions and merge them using some VBA you can find at http://www.rondebruin.nl/tips.htm
under Copy/Paste/Merge examples

Hope this helps