OCHA Consolidated Contact List - Kenneth - PUBLIC
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
YOU WANT TO ADD A NEW PERSON? PLEASE, CHECK FIRST IF THEY ARE IN THE MASTER LIST!
2
(so you don't create duplicates)
3
4
How to add a contact (for everyone)
5
Check MASTER tab to see if contact already exists
6
In the MASTER tab add all the fields for the contact
7
To the right, type "X" at the location of the person as well as the groups where the person belongs to
8
That person will appear automatically in all the groups selected!
9
Don't modify any contact list, it is not needed!
10
11
How to print an attendance list for a meeting / contact list (for everyone)
12
Go to the tab of your contact list
13
File > Print
14
Select fit to width, in headers and footers select Date and Sheet name.
15
Be careful to print only the pages with contacts (there could be empty pages!)
16
Ready to print and go to your meeting!
17
Once you get back from the meeting, please update the master contact list with new contacts, deleting people left or editing mistaken information.
18
19
How to create a list (for IMOs or anyone who needs it)
20
Create a tab with the name of the list/group. Color it in red. Example: "New Group"
21
From the MASTER tab, look at the fields that you want to display in the contact list.
22
Create a new column at the end of the list of columns. In this case "New Group"
23
In the cell A1 of the new created tab, type the following query
24
=query (MASTER!2:944,"select A,B,C,D,E,F,G,H where R is not null order by C,B,A",1)
25
The first list of letters (SELECT) is the fields that you want to display from the master list.
26
The second condition (WHERE R IS NOT NULL) is the letter where you have created the new column in the master list.
27
The third set of letters (ORDER BY) is the order that you want your new list to be sorted by, in this case Cluster, Agency and Name.
28
So the generic would be:
29
=query (MASTER!2:944,"select [COLUMNS THAT APPEAR IN THE NEW CONTACT LIST] where [COLUMN OF THE NEW LIST IN THE MASTER TAB] order by [COLUMNS TO ORDER BY]",1)
30
Delete all the columns to the right of the last column with headers -- to facilitate the printing process
31
Change the tab color to red and Protect ths tab (right click > Protect > This sheet > Show a warning)
32
Your list is ready to go !
33
34
How to remove a list (difficulty: medium / IMO suggested)
35
Remove the tab with the list
36
Take a look and write down all the lists that are to the right of the one you are going to delete
37
In the master list, remove the column of the list
38
In the list you wrote down, add the letter of the column where they appear now.
39
For all the lists that you wrote down, those lists changed their column letter.
In all the tabs of those lists, you have to change the letter that appears in "WHERE R IN NOT NULL" to the previous letter (the one you wrote down).
40
41
How to add a new field to the master list (only do this if you know what you are doing / IMO suggested)
42
If you add a new field/column to the master list, all the queries of all the lists have to be modified.
All the columns to the right will be shifted one column, so in all the queries of all the lists all the letter that were to the right of the new one should be updated with the new letter
43
44
If the table Master table is not visible or missing names
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...