View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
minxy11
 
Posts: n/a
Default 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