I don't see your address.

Héctor Miguel wrote:
hi, Frank !

... set up a way to search for information on individuals... (some 20,000 rows)
... now... we sort ascending, expand the search, find the name... then look for what we want
[quoted text clipped - 6 lines]
... I'm building this for a user who is all but computer illiterate, so the easier to run the better
I'm getting better with VBA, but still have a very long way to go, and can't figure out how to make this work [...]

some ideas...
- create a named dynamic range w/ unique individuals' name entries
http://www.cpearson.com/excel/duplicat.htm
- link that named range to a data validation list [a cell in another worksheets for names picking]
you will be able to 'detect' for the selected name which are the 'matching rows'
- do as above -for 2 more validated cells- to choose a date range [from...to]
- 'fill' a summary report 'extracting/formulating' based on 'rows-count' for 'matching-entries'
- names as 'Print_Area' can also be re/defined as dynamic ranges
- [probably] you wili need no vba [or maybe just a few]

I can not figure out about your actual data lay-out, [for a more detailed examples] but...
if you think this may work and you want send to me [a sample of] your data [NO linked workbooks]...
please, fell free to do so {just remove 'NO...SPAM...PLS' fom my e-mail address]

hth,
hector.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200508/1