Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
receiving cell value after deleting source
I have a form into which I want to load values from a list. I have three
forms on one page. How can I load the forms from the list and have the forms updated when I add or delete an item from the list. (Instead of a REF in the receiving cell). When an item is deleted from the list, I want the new item that moves into the same positiion in the list to replace the item on the form. I am using 2007. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
receiving cell value after deleting source
You could try INDIRECT. For instance:
=INDIRECT("A2") will always direct your formula to the cell A2, regardless of if you delete it. Due note that you lose the ability to copy this formula down/across and have XL infer that you want reference to move with you. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Morto Kopor" wrote: I have a form into which I want to load values from a list. I have three forms on one page. How can I load the forms from the list and have the forms updated when I add or delete an item from the list. (Instead of a REF in the receiving cell). When an item is deleted from the list, I want the new item that moves into the same positiion in the list to replace the item on the form. I am using 2007. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
receiving cell value after deleting source
OUTSTANDING.
Thank you. "Luke M" wrote: You could try INDIRECT. For instance: =INDIRECT("A2") will always direct your formula to the cell A2, regardless of if you delete it. Due note that you lose the ability to copy this formula down/across and have XL infer that you want reference to move with you. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Morto Kopor" wrote: I have a form into which I want to load values from a list. I have three forms on one page. How can I load the forms from the list and have the forms updated when I add or delete an item from the list. (Instead of a REF in the receiving cell). When an item is deleted from the list, I want the new item that moves into the same positiion in the list to replace the item on the form. I am using 2007. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep total of cells in a cell after deleting source data | Excel Discussion (Misc queries) | |||
Deleting cells from chart source data, causing problems | Excel Discussion (Misc queries) | |||
Receiving Spreadsheets Inline | Excel Discussion (Misc queries) | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel |