| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Formulas
I have a sheet that contains a number of formulas, every day the sheet is copied, labeled as todays and the data removed, today data put in. The amount of rows in the data inserted varies from day to day. Ive go a number of formulas analysing the data inputted to the sheet that get shifted when the old data is removed and the new data input. Does anyone know a way of making the formulas entered in excel stay as they were no matter what. Hope someone can help as this is driving me nuts!! Ben -- benjam_in ------------------------------------------------------------------------ benjam_in's Profile: http://www.excelforum.com/member.php...o&userid=36295 View this thread: http://www.excelforum.com/showthread...hreadid=567769 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Moving Formulas
When you copy your data do you click Edit, Move or Copy sheet..., and click the Create a copy box? If you don't, you should. -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=567769 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Moving Formulas
raypayette Wrote: When you copy your data do you click Edit, Move or Copy sheet..., and click the Create a copy box? If you don't, you should. That copies the formulas nicely, but when the new sheet is edited as described it changes all the cell references! This is what I am trying to stop happening. -- benjam_in ------------------------------------------------------------------------ benjam_in's Profile: http://www.excelforum.com/member.php...o&userid=36295 View this thread: http://www.excelforum.com/showthread...hreadid=567769 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Moving Formulas
Have you tried making absolute references like $A$1 instead of A1 ? -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=567769 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Moving Formulas
raypayette Wrote: Have you tried making absolute references like $A$1 instead of A1 ? Just tried that :-( the refenerces are still moving. -- benjam_in ------------------------------------------------------------------------ benjam_in's Profile: http://www.excelforum.com/member.php...o&userid=36295 View this thread: http://www.excelforum.com/showthread...hreadid=567769 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Moving Formulas
Any ideas anyone? -- benjam_in ------------------------------------------------------------------------ benjam_in's Profile: http://www.excelforum.com/member.php...o&userid=36295 View this thread: http://www.excelforum.com/showthread...hreadid=567769 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How prevent formulas to get external references/path to current workbook? | Excel Worksheet Functions | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| locking formulas?? | Excel Discussion (Misc queries) | |||
| Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
| pasting or moving formula cells without updating formulas | Excel Discussion (Misc queries) | |||
Linear Mode
