Worksheet - Copy rows

[cware]

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?

 

[Gord Dibben]

Select columns A:E

Data>Filter>Autofilter on column E for "T"

Select columns A 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