software

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: www.excelforum.com/member.php...oamp;userid=32848
View this thread: www.excelforum.com/showthread...hreadid=527116After you copy the cell......go to the destination cell, right click
and hit PASTE SPECIAL, then select Values and you should be good.