| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
30 fields each to be checked by 1000 people
ss containing 1000 rows ( one row per person)
optimum way to produce table/chart (1 page per person) which can be distributed for checking. 3 columns required: 1 = field description; 2 = current information being held; 3 = blank (to allow amendments to be entered). Though of using Mail Merge to populate Word Doc. from excel other suggestions? -- Concord |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
30 fields each to be checked by 1000 people
Try this...
=INDEX('Road Cash Accounting'!$AH:$AH,MATCH($CU13,'Road Cash Accounting'!$A:$A,0)) Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Concord" wrote: ss containing 1000 rows ( one row per person) optimum way to produce table/chart (1 page per person) which can be distributed for checking. 3 columns required: 1 = field description; 2 = current information being held; 3 = blank (to allow amendments to be entered). Though of using Mail Merge to populate Word Doc. from excel other suggestions? -- Concord |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
30 fields each to be checked by 1000 people
Sorry, I have wrongly posted my answer in your query.
-------------------- (Ms-Exl-Learner) -------------------- "Concord" wrote: ss containing 1000 rows ( one row per person) optimum way to produce table/chart (1 page per person) which can be distributed for checking. 3 columns required: 1 = field description; 2 = current information being held; 3 = blank (to allow amendments to be entered). Though of using Mail Merge to populate Word Doc. from excel other suggestions? -- Concord |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
| how can I convert data with fields in rows to fields as columns | Excel Discussion (Misc queries) | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| 1000+$K$5/1000 -what does $ indicate in formula | Excel Worksheet Functions | |||
| Can I insert a box on excel that can be checked and un-checked? | Excel Discussion (Misc queries) | |||
Hybrid Mode
