Tony,

This could be accomplished with a little bit of VBA.

--
Regards,
Eddie
http://www.HelpExcel.com


"tonycd" wrote:

Dears

I have create a questionnaire worksheet from excel and let the peoples input
the data on every questionaire worksheet. I just want to create a another
summary worksheet and collect their data into one worksheet. Would you please
tell me how to link up with two excel worksheet. Or using access database
instead. thanks.