Greetings all!

I am working with an 07 Excel spreadsheet and would like to use the Text to
Columns feature. It is working just fine. However, I'd like to take it one
step further and have the destination cell be on a separate spreadsheet.
When I change the destination, I get an error message that says Destination
reference is not valid.

Here is what I have listed for the destination: =Sheet2!$A$2

Thanks for your help!