Currently Being ModeratedJan 31, 2013 2:01 PM (in response to VRS)
There are two things to be done when adding to that summary table.
1. Add a Row by clicking the Add Rows handle.
2. Type the new category name into Column A.
Notice how the formula in Column B has been retained, but is awaiting the entry of a Category Name.
The name must exactly match the name in the Transactions table.
Currently Being ModeratedJan 31, 2013 3:13 PM (in response to Jerrold Green1)
Jerry, thanks for your reply and suggestions. However, what you said is exactly what I had done previous to posting my request for help. After adding the row, I did enter the exact name under Transactions but the cell under Amount remained blank.
Also, I have deleted the row and repeated the operation with the same result. No amount was picked up from the Transacations.
Do you have any other suggestion?
Thanks again for your response and help,
Currently Being ModeratedJan 31, 2013 3:32 PM (in response to VRS)
Try my procedure with a new document from the Template and see if it works. If it works on a new template, then there is something you did prior to adding the row that has affected the autofill feature.
Or, if you don't care to look for the cause, just Copy one of the Amount cells that are working properly and Paste it into the new row.
Currently Being ModeratedJan 31, 2013 5:45 PM (in response to VRS)
Jerry, your suggestion solved my problem when I copied the formula from the preceding Amount cell. This save a lot of time for me but I will pursue the cause later.
Thanks for your help.
Currently Being ModeratedFeb 1, 2013 5:00 AM (in response to VRS)
The most likely cause for the autofill not working is that you did something that changed one of the cells in the Amount column. Autofill will only work if all the expressions in that column's body rows are exactly alike. If you added a blank or altered (not just new, but different) row above, for instance, that would kill autofill.