Hey all,

I've been playing around with Access and Excel today, and I'm starting to
think that Excel is the way to go. But for this project, there are a couple
things I need to do, and I'm not sure if Excel can do it.

Issue 1: I have 3 different data sets all for the same person (each person
has a unique key). Is there a way to use either a button or a radio button to
choose which data set to display?

Issue 2: Each person needs to be assigned to a group. A tally of each group
would be kept on another sheet. If I use something like a drop-down list to
assign people to each group, is there a way to have Excel automatically
update the other sheet as soon as that selection is made? Or maybe a way to
force a refresh?

Thanks!
Dave