HowdyI sue Excel 2010.
When I copy a worksheet from another excel file into another, it copies the values and not values and formulaes.
Any suggestions to copy the cells like for like please?
Muchos gracias
Replies (5)
Please login or register to join the discussion.
Click on 'Paste Special',
Click on paste special '123 value and source formatting' You may have to reset numbers to decimal places required, and column widths.
It may be overkilling, but it is easy to do it with macro as you can apply more than two options in one step.
re
it sounds like you have two instances of excel open to me. Close down oneof the files and re-open through the excel instance that is left. Then try again...I might be wrong but it sounds like that...