Copy Modified Worksheet 1 Data to Worksheet 2
 

The template for worksheet 1 has a Tile, Date, and then data cells. The template for Worksheet 2 has a different Tile, same date, and same data columns as worksheet 1 EXCEPT worksheet 2 will contain only those rows from worksheet 1 which have a specified value in a specified column. The data cells for worksheet 1 has all records from a database and are automatically filled in. After worksheet 1 is filled in, I want to either automatically copy the data cells from worksheet 1 to worksheet 2 and perform the necessary filtering as the copy is done or copy all the data from workseet 1 to worksheet 2 and then filter the data (or another way if better). The data transfer form worsheet 1 to worksheet 2 MUST be done automatically AND only after worksheet 1 data is available. Any body have any code or snipets that can be modified to to this ???

Thanks