Hello there, here is another pathetic newbee with an even more pathetic question.
The goal: To have a questionare accessable by multiple users (preferably one book, not multiple books specific to each user), to log answers (from a list). Then to have an external book/sheet track and summarize (tally - using countif currently) the quantity / repitition of each list value.
Is it possible to have a single book for all users which when saved, updates another book (or dbase) not by replacing values but by adding to the total. ie the dbase or dbase book tallies all saves. .. ?
This service is not offered via an internet, just a folder on a shared disk.
Currently (I am still in the build process) I have multiple books specific to each user for the questionare, and a second book which summarizes / tallies.
two problems with this method, other that it's ineffeciency:
1- reading data from a closed file
2- the large number of users (50+)
Suggestions PLEASE !!!
I have no experience with VBA ...
Thanx