Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make number of "static" fields stay the same when copying?
The heading says the most of my problem really. When I copy just one square og many the numbers will increase or decrease whether I copy them down or up the sheet. I want most of the numbers to increase, but there are some static information on page 2 that I don't want to increase. Then the formula will go wrong when it hits nothing or a strange value. Are there som way of telling excel wich are to be "static" and not? -- MrHaugen ------------------------------------------------------------------------ MrHaugen's Profile: http://www.excelforum.com/member.php...o&userid=36191 View this thread: http://www.excelforum.com/showthread...hreadid=560195 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make number of "static" fields stay the same when copying?
"MrHaugen" wrote in
message ... The heading says the most of my problem really. When I copy just one square og many the numbers will increase or decrease whether I copy them down or up the sheet. I want most of the numbers to increase, but there are some static information on page 2 that I don't want to increase. Then the formula will go wrong when it hits nothing or a strange value. Are there som way of telling excel wich are to be "static" and not? Look in help for the difference between absolute, relative, & mixed addressing. -- David Biddulph |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make number of "static" fields stay the same when copying?
Thanks! You are my hero. You should have your own statue -- MrHaugen ------------------------------------------------------------------------ MrHaugen's Profile: http://www.excelforum.com/member.php...o&userid=36191 View this thread: http://www.excelforum.com/showthread...hreadid=560195 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
How to make the cell or font color red if the number is negative? | Excel Worksheet Functions | |||
How do I secure borders, make them unaffected by copying or draggi | Excel Worksheet Functions | |||
How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions | |||
How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions |