Ok, I used a formula in column H of Sheet 1. This formula used info from various other columns in Sheet 1What I want to do is to copy these new numbers in column H and past them in another column in another sheet. The problem is, no matter how I try to do this, it copies the forumla in each box of column H, not the numbers produced by this formulaAnyone know how I go about doing what I'm trying to accomplish? Am I even making sense with what i'm asking?
9/19/2010 5:27:45 PM
Paste Value instead of just paste.
9/19/2010 5:30:25 PM
thanks, now you see why i rarely try to be productive while watching football
9/19/2010 5:31:59 PM