Macro to query set of data

[CharlieZangel]

This is what I am trying to do. I have collated some data from about 12 sheets in the workbook on the 13th sheet. Sheet13 has data in rows A:T. Now I would like to be able to "query" the collated data based on a cell on sheet 14. So for example in B2 on the 14th sheet, I want to be able to enter an employee identifier number (which will change depending on which employee I am trying to gather data for), and when I run the macro, it will return all the records (rows of information) for that particular employee from the collated data on sheet13. So that as long as the number entered into cell B2 on Sheet14, is found in column D on Sheet13, I would like for the data record to be displayed in A5:T5 and down on Sheet 14.

I hope I have explained this well. Thanks in advance for your help

[oeldere]

Have you tried using a filter for that.

Excel 2007 => data => filter

[CharlieZangel]

For reasons that I dont want o bore you with, a filter will not be suitable for what I am trying to do. Is there a way to program filtering thorugh macros and dissplay the filtered result in Sheet 14