copy data between sheets, but not the formula
 

Hi, im using excel to record sales. in the input sheet i have varibles
such as the total cost of the sale, employees name ect.
now what i want to do is extract the varibles from the cell and move
them into my past sales sheet. sounds easy to me, but i want it to like
save into the past sales sheet so that when i input another new sale it
wont just change the same cells in the past sales sheet.

i used to use vb not excel
basicly i wanna extract the visible varible and not the formula.


--
minxy11
------------------------------------------------------------------------
minxy11's Profile: http://www.excelforum.com/member.php...o&userid=32848
View this thread: http://www.excelforum.com/showthread...hreadid=527116

copy data between sheets, but not the formula
 

After you copy the cell......go to the destination cell, right click
and hit PASTE SPECIAL, then select Values and you should be good.