Hi,

I'm looking to create a master spreadsheet that I will add new information to on a daily basis. I want to have this data transferred to another sheet automatically as new data is added based on defined selection criteria.

Do I need a macro to do this or is there a formula I can use?

I'm using Excel 2007.

Thanks for your help.

Wagstex