Here's a related question. Using the above sample file, what if I wanted to filter the list (Corn for Grain as an example) and copy all the visible values from the 2009 column to the 2008 column. I can't seem to get any combination of pastespecial to work for me. Any ideas? Thank You