I'm creating a worksheet name 'current' in which the data is extracted from the server. When server adds new information, new row of these information needs to be appeared in the 'current' worksheet at the last row and shows 'new' in first column. User can update new information from the 'current' worksheet by column and 'new' needs to be shown in first column as well. The 'new' needs to be amended everyday. At the same time, I would like to create another worksheet which named as 'past'. In 'past' worksheet, all the data in 'past' worksheet will be automatically transferred to 'yesterday' worksheet about 7pm each day which is being updated everyday as well. Please help.

Thanks a lot.