copy data between sheets, but not the formula

M

minxy11

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.
 
C

ChuckF

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