help needed urgently

[excelisfoxy]

Hello Guys,

I really need help from someone that can help with a problem I have, the problem I have is that I need to setup a report from a data on on of the tabs and the report needs to go in a separate tab but I would like on the report tab to be able to search the data then produce the reports with each of the transactions that relates to what I am searching for I hope you understand where I am coming from

 

[Andrew Poulsom]

Welcome to MrExcel.

To get help you will need to be a lot more specific. And it's unwise to publish your EMail address like that.

 

[ZPhantom]

As i understand it, you may want to have a look at pivot tables
(http://en.wikipedia.org/wiki/Pivot_table)

ZP

 

[excelisfoxy]

Hey ZP,

Thanks for the reply and thanks for telling me about pivot tables its just that I'm not over keen on them

 

[ZPhantom]

Dont blame you, their not my favourite. but they are a quick easy way of getting what your after