Nice to know. Pl. mark the post as answered to help other users with similar
requirment.
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"wx4usa" wrote:

On Oct 20, 10:48 am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64)
& "hotmail.com" wrote:
Downloadhttp://www.contextures.com/ProductsList.zipfromhttp://www.contextures.com/excelfiles.html#DataValfor an excellent example
of how to do what you want...
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...

"wx4usa" wrote:
I have a database in excel

Columns look like this...Account, date, amount, description

Can excel do a report for me that lists all transactions for an
account?
Ex. enter Account 12345 and then a list appears on a separate
worksheet.

NOT using AUTOFILTER?? Is that possible? With index match somehow??

that works great! Thanks