Hi,

When I use fliter, how can I copy and paste the data in another column? For
example:
When I filter column A with "Texas", I want to copy the data in column B
into column C. However, as column A is in fliter, I can't do this. Can anyone
have an idea to solve it? Thanks.


Column A Column B Column C
1 Texas A
3 Texas B
5 Texas D
6 Texas F