Can Excel List specific data from a list? NOT Autofilter??

[wx4usa]

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??

 

[Sheeloo]

Download http://www.contextures.com/ProductsList.zip from
http://www.contextures.com/excelfiles.html#DataVal for an excellent example
of how to do what you want...

 

[wx4usa]

Downloadhttp://www.contextures.com/ProductsList.zipfromhttp://www.contextures.com/excelfiles.html#DataValfor an excellent example
of how to do what you want...

that works great! Thanks

 

[Sheeloo]

Nice to know. Pl. mark the post as answered to help other users with similar
requirment.

 

[wx4usa]

Nice to know. Pl. mark the post as answered to help other users with similar
requirment.

How do I mark as answered?

 

[Sheeloo]

Click on "Yes" to the question "Was this post helpful to you?" if you are
using the web interface.

 

[David Biddulph]

Sheeloo,

If you had looked at the message headers of wx4usa's message to which you
were replying, you would have seen that the message came via Google groups,
rather than via Microsoft's web interface to the newsgroups.

Please remember that it causes confusion to users to refer them to a
facility which doesn't exist on a newsgroup, and frequent references to such
a facility cause annoyance to other contributors accessing the newsgroup
directly.

 

[Sheeloo]

Hello David,

No, I did not notice that. I will take care in the future.

Don't you think marking a question as answered is important? If yes, then
what is the best way to handle it for those who are using newsreaders...?

 

[Sheeloo]

David,

Got your point. It makes sense.

I will not ask the user to mark as answered in future.

Thanks,
Sheeloo