Unanswered: inserting copied cell between different worksheets of the same workbook
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
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.