Bingoo!!! your solution works and make my life easier. Thankyou soo much for the solution. One thing what I need is when I fill my form sheet auto update on live spreadsheet but the problem is that new record at on row 1. I want to add new entry at the bottom because when I add my Comments for each entry and when I add new entry old record moves down and new record at row one so the comment of last added entry will be shown beside the new entry and so on. Simple I want to add new entry at the bottom how can I achieve this Please help.