I don't know if this is possible but what I want to do is link cells based on
if another cells is marked. Example: Have a sheet called Dinners, on that
sheet you have the persons name and then columns for certain dinners. Then I
have seperate sheets for each dinner. I want to automatically transfer the
name (s) of the person (s) that want that specific dinner. I know I can do a
sort and then copy paste but I don't want to do that. I want it to update as
they are entered. Is this possible? Thanks!