Hi
I am able to autofilter the table with a criteria on Column C, but I can't figure out how to mirror the visible cells on column C, on column B. Is that possible to do?
Example
<TBODY>
</TBODY>
I want to filter column C to show only February and March dates, and overwrite the corresponding rows in Col B with the same dates in Col C.
This is a simplified version of what I am trying to do. In reality The column B information overwritten periodically, then further updated with information collected from several different sources.
I appreciate any help you can give me here.
I am able to autofilter the table with a criteria on Column C, but I can't figure out how to mirror the visible cells on column C, on column B. Is that possible to do?
Example
Col A | Col B | Col C |
SN0001 | 1/31/2013 | 1/15/2013 |
SN0002 | 1/22/2013 | 2/28/2013 |
SN0003 | 3/30/2013 | |
SN0004 | 4/18/2013 |
<TBODY>
</TBODY>
I want to filter column C to show only February and March dates, and overwrite the corresponding rows in Col B with the same dates in Col C.
This is a simplified version of what I am trying to do. In reality The column B information overwritten periodically, then further updated with information collected from several different sources.
I appreciate any help you can give me here.