| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Hybrid Mode
