UPdate Dynamic List

Hello All,
I have posted this question before but did not get help because I was told that I was not clear. I am now trying to clarify of what I am trying to accomplish if you don't mind. I have list on column A and I want the list on column A to reflect always the list on column J. Column J is the source for Column A so I want to insert new row or delete row from column A based on column J. For instance, if new item is added into column J then I would like to insert new row in column A with the new item in there and so forth. The reason I am inserting or deleting rows because I want to keep the format in my sheet. Pls. see attached for more details. There is a reason I want to do this way but that needs more explanation and I am trying to be short on my post. Thank you in advance for your help.

Here's quick way using an array formula:

1. Select cells A19:A29. This is the current items in your example.
2. In the formula bar type =J2:J13
3. Press ctrl-shift-enter
Cells A19:A29 will now be group together in an array formula. When you insert a row to include the new item in row J, the array in A19:A29 will be extended to include the new range.

Thanks for your quick reply. Can you help me with something like vba code that does this automatically. The list i showed in my sample file was just for a sample for just simplicity purpose. I have more data and other reports in that sheet. Thanks for your help

How's this?
I used the _Change Event on the worksheet to copy all of column J to column A with an offset. Note that the _Change routine will be called recursive as the data is copied from column J to A.

Let me know if it works for you.
Copy of Book10.xls

Thanks for your help. This is realy working fine but with one problem. How can i keep the format the same on column A? If i un check couple of items from the pivot table on column J ofcourse column A will change but will not keep the same format. I want always keep the same format on column A like keep 'Grand Total' bold and yellow. Pls. try to un check or recheck couple items from the pivot and see the results on column 'A' just to see what i am trying to say here. Thank you all for your help. See attached for more details.

I didn't realize you were working with a pivot table and I'm not really a pivot table expert. I think what I would do is modify the Worksheet_Change routine to scan down the A column after the copy was done and set the format of each cell as I would like it. I have added some code and comments to that routine to guide you.Copy of Copy of Book10.xls