Creating an auto updating list from a separate table

[dek8ce]

I'd like to create a list on a separate sheet that automatically updates when a table is changed on another sheet in the same workbook.

For example, let's say I have a table (table1) on sheet1 that has 1,000 rows of data. I'd like to create a new table (table2) on sheet2 that only pulls certain rows based on a selected criteria. I want table2 to automatically update (and grow) as I place new rows of applicable data into table1.

Thanks so much!
-David

 

[Perpa]

I'd like to create a list on a separate sheet that automatically updates when a table is changed on another sheet in the same workbook.

For example, let's say I have a table (table1) on sheet1 that has 1,000 rows of data. I'd like to create a new table (table2) on sheet2 that only pulls certain rows based on a selected criteria. I want table2 to automatically update (and grow) as I place new rows of applicable data into table1.

Thanks so much!
-David

David,
Check out the code provided by JLGWhiz at the following link. It uses a change to cells in the Range(D2:E & Lastrow) on one worksheet to initiate copying cells in a row from specific columns to another worksheet. Maybe this will give you some ideas of where to start.

http://www.mrexcel.com/forum/excel-...-copy-part-row-another-sheet-values-only.html

Perpa