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

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

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