Auto Populating & Name Recognition between Worksheets

I have a very large worksheet with alot of information and need some help!

I want to create a seperate sheets which allow the name to be recognized in
the original worksheet and then auto populate the data into the original
worksheet. For example: if I type "Doe, Jane" into worksheet 2, I want it to
recognize "Doe, Jane" where it was previosuly entered in worksheet 1 and then
have all the data copy into worksheet 1. Does this make since or is it even
possible? HELP!
--
Leigh Anne

Check out some of Ron's articles on creating summary sheets (section is about
halfway down the page labels "Copy/Paste/Merge examples":
http://www.rondebruin.nl/tips.htm

I think in your case you want to look at this one:
http://www.rondebruin.nl/summary.htm
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Leigh Anne" wrote:

I have a very large worksheet with alot of information and need some help!

I want to create a seperate sheets which allow the name to be recognized in
the original worksheet and then auto populate the data into the original
worksheet. For example: if I type "Doe, Jane" into worksheet 2, I want it to
recognize "Doe, Jane" where it was previosuly entered in worksheet 1 and then
have all the data copy into worksheet 1. Does this make since or is it even
possible? HELP!
--
Leigh Anne