User not logged in - login - register
Home Calendar Books School Tool Photo Gallery Message Boards Users Statistics Advertise Site Info
go to bottom | |
 Message Boards » » Excel Question Page [1]  
ndmetcal
All American
9012 Posts
user info
edit post

Ok, I used a formula in column H of Sheet 1. This formula used info from various other columns in Sheet 1

What 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 formula

Anyone 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

nacstate
All American
3785 Posts
user info
edit post

Paste Value instead of just paste.

9/19/2010 5:30:25 PM

ndmetcal
All American
9012 Posts
user info
edit post

thanks, now you see why i rarely try to be productive while watching football

9/19/2010 5:31:59 PM

 Message Boards » Tech Talk » Excel Question Page [1]  
go to top | |
Admin Options : move topic | lock topic

© 2024 by The Wolf Web - All Rights Reserved.
The material located at this site is not endorsed, sponsored or provided by or on behalf of North Carolina State University.
Powered by CrazyWeb v2.39 - our disclaimer.