Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    21

    Unanswered: inserting copied cell between different worksheets of the same workbook

    Hi there

    I have been trying copy whole columns from one worksheet into another worksheet of the same workbook but everytime I do this, the values that appear in the destination worksheet are different from the source.any ideas why?Pls help.Thanks

  2. #2
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas, USA
    Posts
    68
    Are there formulas in the cells you're trying to copy? If so, you'll have to Edit, Paste Special, Values to make sure you're getting an exact copy of the values as they are in the source sheet. If you want the new copy to always be the same as the original (even when they change), you need to use a formula in the new cells to reference the original cells.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •