How to Link a contact sheet to database

[Productionguy]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I've just begun working in film productions and have been creating the contact sheets for our shoots. I want to create a database of people we've worked with, (Directors, D.P.'s, production assistants) and link it to the contact sheet so when I get the director row, I can pull up a list of all the directors we've worked with and insert the appropriate contact info. The contact info would info involve multiple entries, ie. name, phone, email, ect.

I'm new to excel but am pretty tech savy. If someone can push me in the right direction, it would be greatly appreciated.

 

[John McGhie]

Excel is not the application to do this in. A dedicated Contact Manager
will do a much better job. Even Entourage's Address Book is already set up
to do what you want without fiddling around.

If you have some other reason to do this in Excel (for example, if you want
to enter hourly rates and calculate time-sheets for these people) then you
need Excel's Outlining function.

They left it out of the Excel 2008 help.

See here:
http://office.microsoft.com/en-us/excel/HP052292731033.aspx

The commands you need are on the Data>Group and Outline menu.

Hope this helps

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I've just begun working in film productions and have been creating the contact
sheets for our shoots. I want to create a database of people we've worked
with, (Directors, D.P.'s, production assistants) and link it to the contact
sheet so when I get the director row, I can pull up a list of all the
directors we've worked with and insert the appropriate contact info. The
contact info would info involve multiple entries, ie. name, phone, email, ect.

I'm new to excel but am pretty tech savy. If someone can push me in the right
direction, it would be greatly appreciated.

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]

 

[Productionguy]

Thanks for the reply. I'm using Excel because the contact sheet they use is in Excel, but I will play around with Entourage as well.