I have a workbook that I created in excel 2003, it has several worksheets
that require some of the same information in different cells. Can I create a
worksheet at the end of all the other worksheets that contain all the
information and create a drop down list (say using the name of the person) on
the other sheets to pull in the information needed in the columns required.
If more information is needed please let me know and I can supply.

Thanks chef mike

Yes, more information is needed.

Otherwise we can only guess or remain vague.

Why can't you use simple cell references towards the cells on the last
sheet? Or use a VLOOKUP function to pull over the data?

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"chefmike" wrote:

I have a workbook that I created in excel 2003, it has several worksheets
that require some of the same information in different cells. Can I create a
worksheet at the end of all the other worksheets that contain all the
information and create a drop down list (say using the name of the person) on
the other sheets to pull in the information needed in the columns required.
If more information is needed please let me know and I can supply.

Thanks chef mike