Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Keeping data without losing Formula's
I have a worksheet (named monthly) with a column of data under a certain month (which will change each time data is entered - stocktake). However this column needs to be edited each month and has formula's in it so it will work (not always the same data in the column). I decided to put this data into a yearly sheet under the particular month. The only way I can do it at the moment is to copy and paste special. How do I (or is there a way to) put this data in a sheet that has all the months but under the month that is signified. In other words I don't want formula's in the yearly sheet (can't use vlookup) as I want to keep this sheet with all the data in it! I'm sure it's really simple but I have read the VBA help files and they don't help me. -- Inneed ------------------------------------------------------------------------ Inneed's Profile: http://www.excelforum.com/member.php...o&userid=26330 View this thread: http://www.excelforum.com/showthread...hreadid=396035 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
How do I copy a spreadsheet, keeping the formulas but not the #s | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
saving dbf file without losing data | Excel Discussion (Misc queries) | |||
Formulas in source data | Charts and Charting in Excel |