Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula changes as new data is entered...
I have a master sheet calculating for certain criteria on another sheet.
As new data is added to the "other sheet" (it is being inserted each time at row 3)the formula on the master sheet changes to start array at row 4... next time row 5... etc. So it does not include new data added in the formula. How can i lock this down to not move with each data entry? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula changes as new data is entered...
You can use a hidden row as the first row and start your sum formula after.
-- Don Guillett Microsoft MVP Excel SalesAid Software "SMOKN_ENG_MOM" wrote in message ... I have a master sheet calculating for certain criteria on another sheet. As new data is added to the "other sheet" (it is being inserted each time at row 3)the formula on the master sheet changes to start array at row 4... next time row 5... etc. So it does not include new data added in the formula. How can i lock this down to not move with each data entry? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula changes as new data is entered...
Try absolute row references in your formulae
eg if your formula refers to C3 change it to C$3 and so on...ofcourse it will increase your effort in updating the formula. I am sure someone else will come up with an easier and better solution. "SMOKN_ENG_MOM" wrote: I have a master sheet calculating for certain criteria on another sheet. As new data is added to the "other sheet" (it is being inserted each time at row 3)the formula on the master sheet changes to start array at row 4... next time row 5... etc. So it does not include new data added in the formula. How can i lock this down to not move with each data entry? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula changes as new data is entered...
Sheeloo... yeah i tried that actually that is how it was set up initially. it
didn't work. "Sheeloo" wrote: Try absolute row references in your formulae eg if your formula refers to C3 change it to C$3 and so on...ofcourse it will increase your effort in updating the formula. I am sure someone else will come up with an easier and better solution. "SMOKN_ENG_MOM" wrote: I have a master sheet calculating for certain criteria on another sheet. As new data is added to the "other sheet" (it is being inserted each time at row 3)the formula on the master sheet changes to start array at row 4... next time row 5... etc. So it does not include new data added in the formula. How can i lock this down to not move with each data entry? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula changes as new data is entered...
As i was typing my question i actually thought of that and implemented....
that works! Thanks! "Don Guillett" wrote: You can use a hidden row as the first row and start your sum formula after. -- Don Guillett Microsoft MVP Excel SalesAid Software "SMOKN_ENG_MOM" wrote in message ... I have a master sheet calculating for certain criteria on another sheet. As new data is added to the "other sheet" (it is being inserted each time at row 3)the formula on the master sheet changes to start array at row 4... next time row 5... etc. So it does not include new data added in the formula. How can i lock this down to not move with each data entry? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula to change page # when data entered in other page | Excel Discussion (Misc queries) | |||
Macro: Updates a formula or value when a data is entered. | Excel Worksheet Functions | |||
extend formula when data is entered | Excel Worksheet Functions | |||
Data not entered yet - formula calculate blank | Excel Discussion (Misc queries) | |||
Formula Changes when data entered in referenced range | Excel Discussion (Misc queries) |