I've got a spreadsheet I'm using as a PM tool, w/ numbers, emails, links, and a journal (my company will spring for excel but not access). For each project I have a sheet w/ pertinent info for that project. On each sheet is a list of contacts relevant to that project (out of normal view). In the main viewing space I have a scroller that allows me to view the info for one contact at a time w/ a link to their email as well. This is fairly convenient but I'm tired of adding in contacts for every project, especially since many of them overlap. I'd like to be able to add a column in one general contacts list w/ a check mark or something similar if they're involved in a that particular project.
EX. A:A=First Name
B:B=Last Name
C:C=Project 1
D:D=Project 2
E:E=Project 3
Then I add an identifier to each project w/ which they're involved. The contacts table on the "Project 1" sheet will look up all those contacts w/ Project 1 marked.
I would attach a mock up but I can't see anyway of adding one. Any help w/ that would be appreciated as well.
EX. A:A=First Name
B:B=Last Name
C:C=Project 1
D:D=Project 2
E:E=Project 3
Then I add an identifier to each project w/ which they're involved. The contacts table on the "Project 1" sheet will look up all those contacts w/ Project 1 marked.
I would attach a mock up but I can't see anyway of adding one. Any help w/ that would be appreciated as well.
