Can I setup a worksheet to copy data from another worksheet in the workbook
based on the entry in one column? On WS #1, can I have a function that
looks to WS #2, column E and if E="T", then copy that row, column a,b,c&d?
AND have that function repeat itself until the end of WC#2?

Select columns A:E

DataFilterAutofilter on column E for "T"

Select columns A:D and select visible cells.

Copy and paste to WS#1

You could record a macro whilst doing this if it is an on-going operation.


Gord Dibben MS Excel MVP

On Wed, 27 Aug 2008 13:05:01 -0700, cware
wrote:

Can I setup a worksheet to copy data from another worksheet in the workbook
based on the entry in one column? On WS #1, can I have a function that
looks to WS #2, column E and if E="T", then copy that row, column a,b,c&d?
AND have that function repeat itself until the end of WC#2?