copy to sheet in different workbook
Posted on 2011-03-21
I have a workbook with sheet1 which is active everyday at a place of business. I want to modify this wkbk withsheet2 at another site and then when design is finished, copy from old wkbk (sht1) to the new design in the new wkbk (sht2) which will than be used as the only workbook at the place of business. When I try to open wkbk1, copy data, close that wkbk, open wkbk2, and paste special to Sht2, I get a "paste special" screen which reads "Inserts the contents of clipboard as a unicode text format" and I get no chance to paste "values only". I suspect I need two instances of excel 2007 in order to past data into sht2 as "values only". Please advise me on how to do this or what other method is available.
Thanks for you kind attention to this question!
Is there a spellcheck available in this "body" box?