Text to columns 2007

  • Thread starter Thread starter Chimelle
  • Start date Start date
C

Chimelle

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!
 
Nick,

Thanks for the information! I guess I'll just paste on the same sheet and
then copy to new destination if required.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to column where to put result 5
Links error when insert line/row to source workbook 1
select file from which to extract specific data 3
Cell fill color in linked cells? 1
Help with my VBA 5
Need help with a function 1
Copy or Move a spreadsheet 1
drop down list 1

Back
Top