Auto Populating & Name Recognition between Worksheets

[Leigh Anne]

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!

 

[Luke M]

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